Slow uploading problems for new c5 site ~ seeking suggestions
Permalink
Hello,
we just built a beautiful site using c5, hosted on rackspace and it takes 25 sec. to down load - need some thoughts - here is more info after I plugged it into a tool ~
From what the trace did capture, most of the load time of the page was spent issuing 5,336 queries to the mysql database. A default Wordpress install by comparison would make approximately 20 writes to the mysql server. This high number of queries would slow down a site, however this issue is exacerbated within a clustered environment such as ours more so than in a traditional hosting environment as the database is not stored directly on a web server but on a different server requiring a tcp request and response on each mysql query made. I would highly recommend changing the configuration on the site so that not so many mysql queries are required per page load such as consolidating multiple queries, caching the html of the page, or removing the code that is causing most of these queries to be run.
we just built a beautiful site using c5, hosted on rackspace and it takes 25 sec. to down load - need some thoughts - here is more info after I plugged it into a tool ~
From what the trace did capture, most of the load time of the page was spent issuing 5,336 queries to the mysql database. A default Wordpress install by comparison would make approximately 20 writes to the mysql server. This high number of queries would slow down a site, however this issue is exacerbated within a clustered environment such as ours more so than in a traditional hosting environment as the database is not stored directly on a web server but on a different server requiring a tcp request and response on each mysql query made. I would highly recommend changing the configuration on the site so that not so many mysql queries are required per page load such as consolidating multiple queries, caching the html of the page, or removing the code that is causing most of these queries to be run.
In general, though, I've found that, somewhat surprisingly, turning off all caching, makes a positive difference. I had a pretty stock site on mediatemple (ie, a good host), in which about 5% of page loads would take 10 - 30 seconds. "Normal" caching was on, and I turned it off, and I suddenly got reasonable speed loads.
James