I have imported 60,000 of my 130,000 products so far (including categories), each product appears in two categories, but as you can expect, I'm seeing a little slowdown (nothing drastic or that I didn't expect), but I was wondering if anyone had any tips to reduce this.

 

Firstly I would like to remove the dynamic sub-categories from the Browse by Category menu, as I think that would reduce the XML file size and thus performance ?

 

Secondly I would also like to remove the Search results by category: from a search. Try Arsenal and you will see what I mean, as it returns all categories where Arsenal appears and that will be alot (causing un-necessary load on the search)

 

Finally, for the time being (until I finished the upload or see a MASSIVE slowdown), how can I force the user to type at least 4 characters in the searchbox before pressing search, as I see this as a potential killer query if you type just one letter and hit search

 

 

http://www.programmehut.com/store/pc/home.asp" rel="nofollow - http://www.programmehut.com/store/pc/home.asp

1) Removing the subcategories from category navigation: This would require a customization to the function used by the control panel to generate category navigation (pcadmin/genCatNavigation.asp)

2) Remove search results by category: in pc/showsearchresults.asp, find:

pcv_strHideCatSearch = False '// Set to "True" to disable category search

3) Minimum character requirement on search input field: This would require some JavaScript to handle. Here's an example:  http://www.webdeveloper.com/forum/showthread.php?t=178782" rel="nofollow - http://www.webdeveloper.com/forum/showthread.php?t=178782

 

Think I have managed to do point 1 already, I will now attempt points 2 and 3. Thanks for the pointers

 

I've managed to import over 131k products and I still think the performance of both frontend and admin is acceptable, I do have plans for more products so no doubt it will become a problem eventually ?!?

I don't know what I (wasn't) thinking here. Removing sub-cats from the category navigation is an option in the control panel under Generate Category Navigation.