ProductCart Shopping Cart Software Forums : Slow Category/Product Loading https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 21:22:41 +0000 Tue, 22 May 2012 16:16:16 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=5137 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Slow Category/Product Loading : I&#039;ll post a support ticket...]]> https://forum.productcart.com/slow-category-product-loading_topic5137_post19642.html#19642 Author: garymike
Subject: 5137
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.
]]> Tue, 22 May 2012 16:16:16 +0000 https://forum.productcart.com/slow-category-product-loading_topic5137_post19642.html#19642 <![CDATA[Slow Category/Product Loading : Hi, 3,000 categories for 4,000...]]> https://forum.productcart.com/slow-category-product-loading_topic5137_post19639.html#19639 Author: Hamish
Subject: 5137
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 :-)   ]]> Tue, 22 May 2012 15:38:50 +0000 https://forum.productcart.com/slow-category-product-loading_topic5137_post19639.html#19639 <![CDATA[Slow Category/Product Loading : Is anyone else experiencing slow...]]> https://forum.productcart.com/slow-category-product-loading_topic5137_post19615.html#19615 Author: garymike
Subject: 5137
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.]]> Wed, 16 May 2012 10:49:03 +0000 https://forum.productcart.com/slow-category-product-loading_topic5137_post19615.html#19615