MSSQL Provider V5 (performance optimization) (

Picture of MSSQL Provider V5 (performance optimization) (
Plugin to speed up website performance. Performance Optimization.
- current rating is 4.23. Total reviews 13
MSSQL Provider V5 (performance optimization) (
Supported Versions: 3.20 , 3.30 , 3.40 , 3.50 , 3.60 , 3.70 , 3.80 , 3.90 , 4.00 , 4.10
Created: 26 April 2013
Last updated: 4 December 2018
Get extension You will be re-directed to the developer's website to download this plugin

Using this plugin you will increase website page loading speed and increase your sales volume. Your website will be more user friendly.

How does it work?

Plugin replaces standard mechanism for retrieving data Entity Framework Linq working on MS SQL Stored Procedures. You can download and try this plugin. Unregistered version is fully operational. It has only one limitation – trial period 30 days. After the expiration, plugin will be disabled.

How many times the speed increases?

Increase depends on data size. You can compare the performance free. Install plugin and compare.

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

Each new nop release has better perfotmance but we reccomend you to check this plugin for your site before purchase.

Plugin works ONLY on MS SQL Server 2005-2017 and never+Azure.

Compatible for NopCommerce 4.10, 4.00, 3.90, 3.80, 3.70, 3.60, 3.50, 3.40, 3.30, 3.20.

Link to our site

Want speed?
[email protected]
8/7/2018 8:11 PM
I was very surprised how slow nopCommerce becomes after a minimum number of products are added to a site.  You are lucky if you have customers with enough patience to actually wait it out to make a purchase.

That's where the FoxNetSoft Performance Optimization tool comes to the rescue.  Add this simple plugin, and your web site magically speeds up to the point where it is worthwhile (modifies how SQL server calls are made).

Any problems or questions? Support is fast and excellent!

This product makes a huge difference.
Was this review helpful? Yes  No (0 / 0)
Perfect Support!
[email protected]
7/14/2017 3:13 AM
I have found out that after extending one of the models in my website I had to go back to support asking for help with plugin, support was quick and resolve my problem! They rock!
Was this review helpful? Yes  No (0 / 0)
Very useful
4/29/2017 12:42 AM
The speed in multistore and acl list settings are amazing.
And the service is great
Was this review helpful? Yes  No (0 / 0)
12/5/2016 9:00 AM
Wish I had found this long ago. What a difference this made for our site! Highly recommended.
Was this review helpful? Yes  No (0 / 0)
Performance & service
11/3/2016 7:29 AM
I'm very happy, my site is very fast now :-)
Check it on

Also the service is incredible, i had an issue with an new template and they solved the issue in a mum of time

Very sastified!

Regards Geoffroy
Was this review helpful? Yes  No (0 / 0)
Great plugin to improve the speed for nopCommerce
3/18/2015 5:08 AM
our webshop was loading in 8-9 sec before using this plugin but after using this plugin speed improves to 2 sec.It is great.
Only 5 stars for this plugin is not sufficient.I think i have to give 10 stars to this plugin and also to their support.
Thanks buddies for all your support.
Was this review helpful? Yes  No (0 / 0)
Our store with Fox plugins flyy!
2/26/2015 5:58 AM
Our store with Fox plugins are faster than ever and the support is more than amazing!!!
Was this review helpful? Yes  No (0 / 0)
That thing deserves a medal
2/25/2015 2:35 AM
I was hopeless before installing the trial. However it gave the the website a super speed. It saved me from many hours of working. I'm definitely buying this. Thanks for such a good solution.
Was this review helpful? Yes  No (0 / 0)
Definate increase in speed
10/16/2014 3:25 AM
Our new site has over 4,000 products and, after install we experienced an noticeable increase in site speed.
Install was easy with no issues.
Was this review helpful? Yes  No (0 / 0)
Still not workinng
1/29/2014 3:40 AM
I have restarted my application(website) from both IIS manager and Admin panel of that website, but still, its showing the same error.
Was this review helpful? Yes  No (1 / 0)
Not allowing to configure!
1/27/2014 9:35 AM

I was trying to configure the plugin but showing this error.
Was this review helpful? Yes  No (0 / 1)
Very Impressed
9/14/2013 1:03 AM
I was skeptical about this plugin at first, mainly because of that 1 star review down there.

If you have a lot of products you must give this plugin a go. We're on version 2.80 and we have around 25,000 variants. It effectively reduced load times on pages with a lot of products by about half. Category details page before 3850 ms after 1650 ms, give or take.

It was much better than I expected, very simple install, the SQL stored procedures look well done (something I've not ventured into).

If you come out with more plugins like this, even just adding more to this one I am definately interested.
Was this review helpful? Yes  No (2 / 0)
not working
6/26/2013 6:50 AM
not seen any improvement in real speed. actually if I speak truly based on load testing reports, then my site performed better without plugin. looking for other alternative
Was this review helpful? Yes  No (1 / 3)