Did you read the "Fines-tuning tips" on Jahia.Org site (http://www.jahia.org/jahia/Jahia/devzone/doc) ?
There's a first list of index that you can complete after some analyze of your system. The best way is to log the SQL requests received by your database and analyze the log after some days to know which request are the more used and determine new indexes.
Which database did you use ? In case of PostgreSQL, try the vaccumdb command (in PostgreSQL bin directory) to update the statistics and optimize the index. On other DB, find the way to update the statistics and optimize the index.
|
I have a performance problem on a jahia web site. I have more than 2500 pages on this site and then this very slow. I am trying to create index on the database. Is anyone has a script to do that ? I use jahia 4.1. I have try to use the p6spy and sql profiling without success. I do exactly what is write on the guide administration guide, but GUI didnt receive a connection. Is anyone can help me? Is any one has a idea about this performance problem? Thanks for your help. Nicolas |
Ghislain CUSSONNEAU
DIRR/DPIL/CIS
CAP 44, Rue Marcel Sembat
44000 Nantes
02 51 84 48 80
CRIL Technology
Technoparc de l'Aubinière
44000 Nantes
02 51 89 64 50
Accédez au courrier électronique de La Poste : www.laposte.net ;
3615 LAPOSTENET (0,34 /mn) ; tél : 08 92 68 13 50 (0,34/mn)
