Re: increase performance

[Gustavo von Goetzen Sanchez]

Hi Christelle,   I think what u can do is use the SqlProfiler , which is a tool that reports the query time and lets u know which queries could be optimized.   Here u find more information about the SQL Profiler.   http://www.jahia.org/jahia/Jahia/devzone/pid/377   about the caches i cant tell u much. but i think its the container cache which u mean, it has less to do with jahia.     I hope i could help,   Greetings     Gustavo           ----- Original Message ----- From: Christelle HUMSKI To: [EMAIL PROTECTED] Sent: Monday, July 26, 2004 8:56 AM Subject: increase performance 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