Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Searching is slow on my site


tlelliott77

Recommended Posts

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

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

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

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

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...