Hi Christelle,
You can find the recommended list of indexes in our Technical FAQ page, here :
http://www.jahia.org/jahia/Jahia/devzone/pid/454#4
Also be aware that Oracle is the slowest performing database with Jahia. Jahia does a lot of requests, and it seems that Oracle is not really designed to handle lots of very simple SQL requests (it seems to specialize more in complicated SQL requests). For top performance we recommend MySQL.
Regards, Serge Huber.
Christelle HUMSKI wrote:
Hi
I use Jahia 4.02 with Oracle 8i, and it's quite slow : it takes 3 seconds for each user at the first call of a page (simple template, just to read). On edition side, it takes sometimes 7 seconds to publish a page (simple template)...
In the mailing - list, I read it's a matter of indexes - I haven't found any one on Oracle - which index should we create ?
What about the caches - should I flush one of them ?
Thanks for answer
