CiviCRM Community Forums (archive)

Hi

I have been noticing that the civicrm/drupal site I setup recently has not being performing well, page load times are sluggish.

Using apache's ability to add the page generation times into the logs, I have noticed most of the log lines are like this:
130.216.52.177 - - [11/May/2010:11:01:40 +1200] "GET /acttesting/civicrm/contact/view?reset=1&cid=2 HTTP/1.0" 200 63605 "http://www.shadowservices.biz/acttesting/civicrm" "Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.1.9) Gecko/20100402 Linux Mint/8 (Helena) Firefox/3.5.9" 1925762

That's 1.92 s page generation time on the end of the log line there. Some other civicrm pages are faster, but even the settings pages are taking at least 1 second to generate.

This is running on a linode VPS for testing, but I also see similar times on a vmware instance running on our dedicated server.

Here is a link to the phpinfo: http://www.shadowservices.biz/phpinfo.php  - this is running ubuntu 9.10 server with nginx reverse-proxying to apache. The mysql is running on the same server as apache and nginx.

Any ideas as to why this is so slow? The first thing i would like to be able to narrow down is whether the slowness is mostly due to time taken for sql queries or not, but I'm not sure how to do this in civicrm. Is there a central sql_query wrapper somewhere that I can enclose by some timing code?

Thanks
Jordan