Guest Posted June 22, 2004 Posted June 22, 2004 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.
mattice Posted June 22, 2004 Posted June 22, 2004 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"
Guest Posted June 22, 2004 Posted June 22, 2004 If I could kiss you from here I would :) Totally solved it !! TY TY TY
Recommended Posts
Archived
This topic is now archived and is closed to further replies.