Re:Index

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 didn’t 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)