MSSQL Provider V2. Performance Optimization.

< 1 2 3 4 >
Posted: November 18, 2013 at 4:52 AM Quote #109282
We have made new improvement.
We rewrited PriceCalculationService.

If you are using a discount Your pages will load faster.
If you are not using discounts the speed does not change.

To update the plugin:

    Backup database.

    Save the old version of the plugin elsewhere.

    Replace the plugin folder by the new version.

    Reboot your website.

After rebooting the website, the module itself will update all settings by running script Update.

No need to UnInstall and then Install the plugin.
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: April 08, 2014 at 2:36 AM Quote #119995
Added support version 3.30.
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: April 24, 2014 at 5:08 PM Quote #121475
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.

Compatible for NopCommerce 3.2/3.3
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: July 22, 2014 at 10:05 AM Quote #126992
Added support version 3.40.
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: July 22, 2014 at 11:27 AM Quote #126998
With all the performance improvements in 3.4, could you share an updated benchmark list like you did for the previous versions?
This post/answer is useful
2
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: July 22, 2014 at 1:34 PM Quote #127003
We plan to do benchmark for version 3.40 next week.
NopCommerce 3.40 has a very good performance.
This post/answer is useful
1
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: January 15, 2015 at 9:50 AM Quote #138467
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
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: June 24, 2015 at 3:49 PM Quote #147631
Added support version 3.60.
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: January 14, 2016 at 10:58 AM Quote #159671
Added support version 3.70.
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: August 25, 2016 at 5:15 PM Quote #174120
Added support version 3.80.
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
< 1 2 3 4 >
Premium support services
  • Dedicated premium support services provided by core developers are intended for persons who run mission critical websites, work on projects with tight deadlines, or want to get dedicated support.
Professional services
  • Want to open a new store? Want to take your store to the next level? Need a custom extension? We can customize nopCommerce to fit your store perfectly. Request a quote to get started.