Forums

Slow Database Queries?

Permalink
Hi I'm suffering from very slow load time on my site, and when I talked to my hosting company about the best way to investigate this they have come back with this comment. I'd welcome any comments from the C5 community as they surprise me.

It seems that your site has slow database queries, which is causing slowness.
The site is hosted on our shared server, where the load can have spikes at times according to the memory usage by each account in the server. If your database queries are not optimized properly, it will definitely increase the server load and the site will load slowly. Please check slow query logs pasted below:
-----------
# Time: 110205 22:18:29
# Query_time: 7 Lock_time: 0 Rows_sent: 9 Rows_examined: 9
use database_name_removed;
SHOW COLUMNS FROM `btNavigation`;
-----------
# Time: 110207 22:17:34
# Query_time: 6 Lock_time: 0 Rows_sent: 14 Rows_examined: 426
use database_name_removed;
select Blocks.bID, CollectionVersionBlocks.arHandle from CollectionVersionBlocks inner join Blocks on (CollectionVersionBlocks.bID = Blocks.bID) inner join BlockTypes on (Blocks.btID = BlockTypes.btID) where CollectionVersionBlocks.cID = '74' and (CollectionVersionBlocks.cvID = '54' or CollectionVersionBlocks.cbIncludeAll=1) order by CollectionVersionBlocks.cbDisplayOrderasc;
-----------
Please contact your developer and correct the database queries written for your site.


I'm looking at average load times of anything up to 20000ms for the front page.

Any pointers you can give me?

The site in question is http://felthamwest.info

Thanks in advance

Mike
TeddyBare
 
madeforspace replied on at Permalink Reply
madeforspace
Just did a speed test on your site and got the whole thing up in about 3.2 secs. Lots of external stuff on that first page that could cause a slow page load.
I am guessing you have gone through all the cache options already.
Gonna have a look around the site now as I used to live not far from Feltham :)
TeddyBare replied on at Permalink Reply
TeddyBare
Thanks for that, I may well try and remove a few of the external things, but I still thought it should work better than it does. I have had another email from my hosts (the MD this time) disagreeing with the previous comment and promising to look at MySQL usage on the server.
TeddyBare replied on at Permalink Reply
TeddyBare
Actually when I looked there was only 3 external links.... one for weather, the petrol prices and then the pagecounter, everything else is local on the same server.

Weather's gone now (it failed a lot anyway) so I'll keep an eye on it for a while.

I have played with the cache, but I see very little difference no matter what I set the settings to.
madeforspace replied on at Permalink Reply 1 Attachment
madeforspace
I am guessing you may have done this already but attached is a screeny of how I see your sites performance.
I am about 1,000 miles away from your server approx 14 hops so I am going to be slower than most.
It could be a time of day thing or maybe the DB is not on the same server.
I have never found Concrete5 to be the fastest but it is still the best. The load times you are experiencing seem way over what I would expect.
This is useful stuff if you have not seen it already.http://www.concrete5.org/documentation/how-tos/developers/five-easy...
Hope you get a solution of some sort.