wildvettes Posted April 12, 2011 Share Posted April 12, 2011 I'm looking to speed up my site and in old optimization posts people are talking about 90ish in a stock oscommerce and getting that as low as 27... Well I just installed KissER and found out my site pages are turning out almost 1700 queries per page : / I don't feel like I've done all that much to my site versus a stock install, so what gives? I have a list of all the queries but don't even know where to begin as I'm not a programmer. Any tips on what I can be looking for in particular? A great deal of them seem to be related to creating the "count" numbers in the product categories and take about .0005 seconds which is .8 seconds for the whole page so should I focus on the longest first? Can I deactivate the product count features easily to reduce those queries? Most seem to look like this, but the times vary, although this one is way higher time wise Number: 110 Time: 0.2082 Seconds. Query: select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '203' Link to comment Share on other sites More sharing options...
wildvettes Posted April 12, 2011 Author Share Posted April 12, 2011 OK so hopefully this makes my problem simpler to fix as it appears to merely be one single issue... 1633 of the 1662 queries look like this almost exactly but with different ID numbers and some of them take much longer than others...I'm guessing this will become further out of control as I continue adding products and categories. Number: 11 Time: 0.0004 Seconds. Query: select count(*) as count from categories where parent_id = '134' Number: 12 Time: 0.0022 Seconds. Query: select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '134' Number: 13 Time: 0.0004 Seconds. Query: select categories_id from categories where parent_id = '134' Link to comment Share on other sites More sharing options...
burt Posted April 12, 2011 Share Posted April 12, 2011 Turn off the category counts for starters. It's a setting in the admin section. Link to comment Share on other sites More sharing options...
wildvettes Posted April 12, 2011 Author Share Posted April 12, 2011 Turn off the category counts for starters. It's a setting in the admin section. You are awesome!!!! My queries dropped to 37 and cut 4 seconds off each pages load time...seriously you are my hero! Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.