Using ProductCart - Slow Category/Product Loading

Print Page | Close Window

Slow Category/Product Loading

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Using ProductCart
Forum Description: Running your store with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=5137
Printed Date: 09-March-2025 at 1:01pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Slow Category/Product Loading

Posted By: garymike
Subject: Slow Category/Product Loading
Date Posted: 16-May-2012 at 10:49am

Is anyone else experiencing slow loading of the edit Categories, subcategories, or products page? Our database is quite large and has over 4000 products with about 3000 categories (including subcategories). The hierarchy is about 4 levels deep before the product is reached in some cases. When the edit category page loads it can take about 5 minutes or more just to show the entire listing before I make edits because it is loading in a depth-first manner. Is there any way that I can optimize this load time by caching this or changing the method of loading to dynamically load each node of subcategories on click? I would even be more happy with the loading if the category tree loaded in a breadth-first method. Any thoughts on this slow loading or some odd setting I may have changed would be greatly appreciated. Thanks.

Replies:

Posted By: Hamish
Date Posted: 22-May-2012 at 3:38pm

Hi, 3,000 categories for 4,000 products seems an unusual ratio. Please raise a support ticket so we can take a look and see if there is any specific advice we can give. In the meanwhile, if anyone else has any ideas please feel free to chip in :-)

-------------
Editing ProductCart Code?

See http://wiki.earlyimpact.com/developers/editcode" rel="nofollow - WIKI Guidelines for Editing ProductCart's ASP Source Code

Posted By: garymike
Date Posted: 22-May-2012 at 4:16pm

I'll post a support ticket soon.

In the mean time, I've found the problem and file in question. Looking at the function ShowCatInfo of the manageCategories.asp file found in the pcadmin folder, the loading issue lies in this recursion (about line 350). The code recursively loads category nodes to maximum depth. I would really like it to load the first level (which I can do), then "on mouse click" perform the recursive load of that node i clicked on. I would think this could be implemented by changing the function to load a depth of one level. Then modify the UpDown function (which controls the plus and minus of categories) to call call ShowCatInfo of the node clicked.

Any help is greatly appreciated. I'm relatively new to this system and should have a support ticket posted soon.