Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Reviews slowing products down?


Guest

Recommended Posts

Posted

After having 3 people try and figure out why only certain products are slow (this one being the biggest culprit: http://thefertilityshop.com/catalog/produc...?products_id=49 )

 

We've narrowed down what seems to be the common denominator for the slowest products..and that's that they have reviews. I've tried repairing the reviews tables (although they seemed to be fine). I was looking to see if anyone might have any other input as to what might be going on. The reviews are all clean..just plain text.

 

Tried Gzip compression, tried removing the text to see if load time was faster. The headers all load fine..it's what is below the headers that are painfully slow on these products.

 

Thank in advance.

Posted

The reviews query that shows on that page is fairly basic - it only gets the number of reviews. I suspect the 'people that also bought this product' module is your resource hog... try excluding that and see if the page loads faster.

 

If so add indices to your tables - especially the ones used by the also_bought queries.

There is an HOWTO on indexes (indices) in the contributions.

 

HTH

Matthijs

"Politics is the art of preventing people from taking part in affairs which properly concern them"

Posted

If I could kiss you from here I would :) Totally solved it !!

 

TY TY TY

Archived

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

×
×
  • Create New...