Rép. : RE : increase performance

thanks !

>>> [email protected] 26/07/04 13:35:45 >>>
Hi,

Here you can find some indexes for your database Oracle:
http://www.jahia.org/download/jahia4/4_0/indexes/jahia4_indexes.sql

But, before applying them, do you have some primary keys on yours tables ?


Regards,

Fabrice Marchon


>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