Improvement?

Hi,

i'm very happy with the performance of the webshop. For the moment are the subcategories not active.

This week there's was time for working on the sub menu.  In the query "FNS_Category_GetAllCategories" i added some code that inserted the categoryid in a new table.
Everytime that the getAllcategories was called a categoryid was filled in a my new table.

The result of this is after a few minutes the table is filled with 100k records.

Is it possible that the clientcode just loaded the categories that is needed for the specific shop?
Now i think there's a loop and loaded all the categories for all shops.


tx Geoffroy

Thank you suggestion.

I added these features.

Version 4.30 - November 28, 2016

+ added new feature 'Load all categories on startup'.
+ added new feature 'Load all manufacturers on startup'.

The plugin works great on the front end.  We have about 100K categories and 60K of products with more being added.  Our webstore is blazing even with the number of records.

However, the NOP Admin is really slow when we try attempt to Manage a Category or a Product.  Is there away for the plugin to run on the NOP Admin as well?

1. What nopcommerce version do you use?
2. Can you describe the problem place in admin mode, step by step and in what place did you wait the answer from the server?