Forums / Install & configuration / Long waiting time to access
Christophe MAILLARD
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 Exponential 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
H-Works Agency
Monday 30 May 2011 8:36:16 am
Have you followed all the necessary configuration to put an Exponential website in production ?
PHP accelerator, ViewCaching, Template Caching, Template Compile...Etc
EZP is Great
Monday 30 May 2011 9:01:12 am
All the modules mentioned were activated
Monday 30 May 2011 9:14:50 am
What i can say is that a classical "blog" website with those configuration options enabled should perform well but if you have a "big" website (lot of contents, ezfind solr indexation, complex layouts) then extra settings must be applied depending on the performance problem.
To resume i'd need more information on the site setup if basic optimization isn't solving the problem.
Damien Pobel
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 Exponential 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
Tuesday 31 May 2011 1:52:57 am
Hi,
After checking with my team, some settings were configured incorrectly.
We changed the following configuration file : var/www/html/settings/override/site.ini.append.php
Now, we have a better response time when accessing the home page.
0 - DNS resolution 0 - Connection 0 - Sending 2.58s - Pending 157ms - Reception
Damien, we'll look at your recommendations and will keep you informed.
Thanks !