Version 2 Logic of operations with such actions as Catalog, Manufacturer, Vendor, CategoryNavigation is rewritten.
Benchmarks. For NopCommerce version 3.30 240 products in the one category. Each product has 20 ProductVariants. 60 products on one page. Example. Your customer opens this category page.
Built-in. First launch CatalogController:Category. duration=00:00:01.1357422 Second launch CatalogController:Category. duration=00:00:00.5986328
After plug-in installation (via Stored Procedures) First launch CatalogController:Category. duration=00:00:00.6396484 Second launch CatalogController:Category. duration=00:00:00.2910157
Plugin works ONLY on MS SQL Server 2005/2008/2008R2/2012.
Benchmarks for NopCommerce version 3.50. 240 products in the same category. Each product has 20 subproducts (ProductVariant). 60 products per page. Store has 2 languages. User opens the category (CatalogController: Category).
Settings: Acl, StoreLimitations, Discounts, disabled Cache product prices. NopCommerce First launch 00:00:01.8339843 NopCommerce Second launch 00:00:00.9091797 NopMSSQLProvider First launch 00:00:00.9169922 NopMSSQLProvider Second launch 00:00:00.3916016 Settings: Acl StoreLimitations IgnoreDiscounts, disabled Cache product prices NopCommerce First launch 00:00:01.7158203 NopCommerce Second launch 00:00:00.5781250 NopMSSQLProvider First launch 00:00:00.9218750 NopMSSQLProvider Second launch 00:00:00.3427734 Settings: IgnoreAcl IgnoreStoreLimitations IgnoreDiscounts, disabled Cache product prices NopCommerce First launch 00:00:01.5937500 NopCommerce Second launch 00:00:00.5888672 NopMSSQLProvider First launch 00:00:00.8867188 NopMSSQLProvider Second launch 00:00:00.3935547 Settings: IgnoreAcl IgnoreStoreLimitations IgnoreDiscounts, enabled Cache product prices NopCommerce First launch 00:00:01.5976563 NopCommerce Second launch 00:00:00.4365234 NopMSSQLProvider First launch 00:00:00.9501953 NopMSSQLProvider Second launch 00:00:00.3740235