tlelliott77 Posted March 3, 2009 Share Posted March 3, 2009 Hi Searching seems to have slowed down to make it almost unusable on my site www.kidzdens.co.uk. It currently takes about 14 seconds for a search to complete. It used to be much quicker at around 3-4 seconds. The slow down may have coincided with my host upgrading MySQL. At that point I had to change a number of queries including one in advanced_search_result.php as follows (changed part in bold): from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c was changed to from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_SPECIALS . " s using(products_id), " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c The original query stopped working when MySQL was upgraded. A similar change has also resulted in incredibly slow page load times in my admin/categories.php I can't find similar problems by searching the forums but wondered if anyone has experienced the same or knows a solution top speed the queries up again. Thanks in advance Tim Link to comment Share on other sites More sharing options...
spooks Posted March 3, 2009 Share Posted March 3, 2009 Just a tip, turn off category counts in admin, it adds a lot of extra queries. Sam Remember, What you think I ment may not be what I thought I ment when I said it. Contributions: Auto Backup your Database, Easy way Multi Images with Fancy Pop-ups, Easy way Products in columns with multi buy etc etc Disable any Category or Product, Easy way Secure & Improve your account pages et al. Link to comment Share on other sites More sharing options...
tlelliott77 Posted March 5, 2009 Author Share Posted March 5, 2009 Just a tip, turn off category counts in admin, it adds a lot of extra queries. Thanks for the tip, though it hasn't speeded up my searches at all. Anyone else got any ideas? Could it be to do with the number of products I have, the fact that they are all in multiple categories, or the number of specials I have active? Link to comment Share on other sites More sharing options...
tlelliott77 Posted March 5, 2009 Author Share Posted March 5, 2009 Solution found. I just needed tooptimize the tables with overhead on my database and it all seems to have speeded up to an acceptable rate. New note in diary for a monthly database optimisation. Link to comment Share on other sites More sharing options...
spooks Posted March 6, 2009 Share Posted March 6, 2009 Thanks for posting your solution, too many just leave people hanging with 'found it' Sam Remember, What you think I ment may not be what I thought I ment when I said it. Contributions: Auto Backup your Database, Easy way Multi Images with Fancy Pop-ups, Easy way Products in columns with multi buy etc etc Disable any Category or Product, Easy way Secure & Improve your account pages et al. Link to comment Share on other sites More sharing options...
ludowhite Posted March 7, 2009 Share Posted March 7, 2009 Solution found. I just needed tooptimize the tables with overhead on my database and it all seems to have speeded up to an acceptable rate. New note in diary for a monthly database optimisation. Hi Tim Can you expalin to a novice how you achieved this operation and whre. Thanks Thanks for Looking Ludo Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.