Long waiting time to access

Monday 30 May 2011 8:17:01 am

Hello,

When accessing the home page of our website we have a long waiting time.

With FireBug, we can see that :

0 - DNS resolution
0 - Connection
0 - Sending
5.89s - Pending
140ms - Reception

We have the following architecture :
2 web front-end servers with eZ Publish 4.4.0
1 database server - Oracle 10G RAC Cluster Mode

When we surf on the site, the times are no better, exemple :

0 - DNS resolution
0 - Connection
0 - Sending
3.63s - Pending
109ms - Reception

Debug mode has been activated, but we have not yet identified the problem;
Do you have any ideas?
Thank you

Christophe

Monday 30 May 2011 9:01:12 am

Hello,

All the modules mentioned were activated 

Christophe

Monday 30 May 2011 1:14:42 pm

Hi Christophe,

first, you have to make sure that most caches are enabled. If it's the case, then you should make sure that your pages are correctly optimized. The usual way of doing this in eZ Publish is too use the cache-block template function to put some parts of the page in cache to decrease the number of SQL queries needed to generate a page. This function has to be used in the pagelayout.tpl or the templates included in it because by default, there's no cache strategy for those templates. You can see the number of SQL queries in debug output table. it's commonly admitted that 10 SQL queries or less to generate a page already in cache (ie in a second hit) is a good result.

Cheers

Damien
Planet eZ Publish.fr : http://www.planet-ezpublish.fr
Certification : http://auth.ez.no/certification/verify/372448
Publications about eZ Publish : http://pwet.fr/tags/keywords/weblog/ez_publish