Hi,
In my nuxeo 5.2 I have 168 entries in my hierarchy table.
When I have access to guest dashboard I have 72,211 calls to
NX_ACCESS_ALLOWED function (I have this information with some debug code
add to NX_ACCESS_ALLOWED function) !
Of course my mySQL server use a lot of CPU (because of NX_ACCESS_ALLOWED
complexity) and page makes a long time to display (up to 5 minutes for
250 documents in a other developer's computer).
Why how many calls to NX_ACCESS_ALLOWED?
Strangely Postgresql seems to be more efficient. I haven't information
about number of calls to NX_ACCESS_ALLOWED function with PG but I think
that Postgresql have a better cache mechanism.
About this, this is my mysql cache configuration :
SHOW VARIABLES LIKE 'query%';
query_alloc_block_size 8192
query_cache_limit 2097152
query_cache_min_res_unit 4096
query_cache_size 134217728
query_cache_type ON
query_cache_wlock_invalidate OFF
query_prealloc_size 8192
Thanks.
begin:vcard
fn:Raymond Bourges
n:Bourges;Raymond
org;quoted-printable:Universit=C3=A9 de Rennes 1;CRI
adr:;;Campus de Beaulieu;Rennes;;35042;France
email;internet:[email protected]
title;quoted-printable:Ing=C3=A9nieur Informatique
tel;work:+33 (0)2.23.23.71.32
note:Mon agenda : http://agenda.univ-rennes1.fr/?calid=bourges&security=1
x-mozilla-html:TRUE
url:http://blogperso.univ-rennes1.fr/raymond.bourges/
version:2.1
end:vcard
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
