Slow Category/Product Loading

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   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.

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
garymike Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 09-May-2012 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote garymike Report Post Thanks(0) Quote Reply Topic: Slow Category/Product Loading 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.

Hamish Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 12-October-2006 Location: United Kingdom Status: Offline Points: 56	Post Options Post Reply Quote Hamish Report Post Thanks(0) Quote Reply 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 WIKI Guidelines for Editing ProductCart's ASP Source Code

garymike Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 09-May-2012 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote garymike Report Post Thanks(0) Quote Reply 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.