arisoy Posted August 2, 2004 Posted August 2, 2004 I've imported nearly 1,700 categories and 28,000 products - now the front page never finishes loading. The page_parse_time log file (w/db queries) logges 1554 lines, primarly lines like this: QUERY select categories_id from categories where parent_id = '523'RESULT Resource id #2358 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '524' RESULT Resource id #2361 It seems the only thing it is doing is getting the product count... In admin the same thing happens for the catalog. I believe this process has to be optimized.
Guest Posted August 3, 2004 Posted August 3, 2004 do u have a link to the site? perhaps if you reword the question or give more detail,
Guest Posted August 3, 2004 Posted August 3, 2004 Results like this: Resource id #2358 often mean that the page is trying to grab the array as the result, as opposed to individual fields. Do any of the product titles includes special characters or something else that could be causing the query to fail or are you positive that it is simply failing because of the sizeof the catalog?
Mark Evans Posted August 3, 2004 Posted August 3, 2004 Turn off category counts in the admin. Mark Evans osCommerce Monkey & Lead Guitarist for "Sparky + the Monkeys" (Album on sale in all good record shops) --------------------------------------- Software is like sex: It's better when it's free. (Linus Torvalds)
arisoy Posted August 4, 2004 Author Posted August 4, 2004 Turning off category counts is the solution to the problem. This is the way to go. I believe the category count database querying should be rewritten. We can't have, in my case, 1600 queries just to list the category counts. Better create an array from the result set and browse through it. Otherwise, I'm extremely happy with osCommerce! Thanks, Alex!
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.