Knowledgebase

one possible explanation for the way in which the server we're on 
suddenly becomes unresponsive for several seconds occasionally, then 
comes back again.

Basically the index filters "music_genre_filter" and 
"record_company_filter" each contain an SQL queries at line 154 
(approx). In both cases the conditional section of the query is 
incomplete, as there is no join between the products table and the other 
tables that the query references. As a result it attempts to join 
*every* active product to each category record matching the main 
criteria and can sometimes get into such a mess that the server (or 
probably the MySQL engine) grinds to a halt until it's finished, times 
out or runs out of space.
If this is present on your servers, I recommend getting clients to add 
"and p.products_id = p2c.products_id" immediately after the "where" 
clause in both locations.

Add to Favourites

Print this Article