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