Hello XWiki-devs, maybe this forum is better than curriki-dev. In short: how can I boost the size of the cache of objects held by hibernate? thanks in advance paul
as you know curriki.org is somewhat of a fat server serving really many requests.
One symptom we are seeing on the production machine only, almost, is: xwiki.getPlugin("curriki").fetchUserGroups(). that sometimes takes more than 1 minute and sometimes much less, all for the same user. On the development machine it takes time with users with a lot of groups only when the hibernate cache is flushed.
My interpretation is that this method is fetching the group and probably a lot more. My answer would be to go low-level.
But another answer would be to ensure that the hibernate cache is big enough so that all these stay in memory. Making this possible would also speed up a huge amount of other things.
Are we talking of the file ehcache.xml's attribute: maxElementsInMemory="10000" ? I sure could raise this by a factor 10 if true.
thanks in advance
paul