Re: increase performance

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