![]() |
Categories and large number of products |
Post Reply ![]() |
Author | |
amscompanies ![]() Newbie ![]() Joined: 25-March-2010 Status: Offline Points: 2 |
![]() ![]() ![]() ![]() ![]() Posted: 01-March-2012 at 6:51am |
Over the last couple of days I have been using the SUPERB product import wizard (I can't fault it). 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
|
|
![]() |
|
Guests ![]() Guest ![]() |
![]() ![]() ![]() ![]() ![]() |
Well, one of these is easy, anyways:
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:
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
|
|
![]() |
|
amscompanies ![]() Newbie ![]() Joined: 25-March-2010 Status: Offline Points: 2 |
![]() ![]() ![]() ![]() ![]() |
Thanks Sean
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 ?!? Edited by amscompanies - 02-March-2012 at 5:07am |
|
![]() |
|
Guests ![]() Guest ![]() |
![]() ![]() ![]() ![]() ![]() |
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.
|
|
![]() |
Post Reply ![]() |
|
Tweet
|
Forum Jump | Forum Permissions ![]() You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |