MS SQL Provider V5 (performance optimization) (foxnetsoft.com)

Picture of MS SQL Provider V5 (performance optimization) (foxnetsoft.com)
Plugin to speed up website performance. Performance Optimization.
- current rating is 4.14. Total reviews 14
MS SQL Provider V5 (performance optimization) (foxnetsoft.com)
Supported Versions: 3.90 , 4.00 , 4.10 , 4.20
Created: 26 April 2013
Last updated: 15 July 2019
$60.00
Get extension You will be re-directed to the developer's website to download this plugin
Description

MSSQL Provider V2 (Performance)

Plugin to speed up website performance (Performance Optimization) (FOXNETSOFT.COM)

Description

Using this plugin you will increase website page loading speed and increase your profits. Your website will be more user friendly. You can enable ACL rules, “limit per store”, you can show the number of distinct products besides each category. After it you will not have any performance degradations.

How does it work?
We made many improvements. Plugin for each nopcommerce release has own improvements.
There are a most important:

Improvement 1.
We moved logic for getting data into MS SQL Stored Procedures for heavy queries.
By default NopCommerce uses Entity Framework for getting data from databases. It is very good framework. Using Entity Framework developers can write one code for all databases (ex. MS SQL Server, Oracle, MySQL, etc.). But we pay performance for our comfort and versatility. NopCommerce generates C# commands (Linq) for getting products, categories, etc. Entity Framework converts these commands to SQL commands (TSQL). Entity Framework generates good SQL code for simple commands. But for non-simple commands it generates non-optimized code. Ex. For getting records from 2, 3 or more tables with many conditions. Entity Framework sends these “heavy” SQL commands to MS SQL Server. MS SQL Server analyses them and makes SQL query plan for getting records from tables. If SQL command is very difficult MS SQL Server can't use optimization for getting records from tables. At last we have 2 problem places “generation SQL command into Entity Framework” and “getting records from table in MS SQL Server”. If your databases isn't large you will not have these problems. You will see them only for big tables and difficult queries. We removed standard mechanism for retrieving data. We wrote SQL commands inside MS SQL Stored Procedures manually. MS SQL Server saves SQL optimization plan for retrieving data for each Stored Procedure too.

Improvement 2.
We try to skip load excess data.
Plugin tries to filter all data on server side.
Example.
You want to load order with some GUID. EF doesn't support casting of GUID to string. NopCommerce must read all orders. If your store has many orders, you will wait some time.

Improvement 3.
Category, manufacturer and vendor pages were rewritten.
If customer opens category page NopCommerce reads categories for breadcrumb, featured products, products from these categories, etc. For each group of object NopCommerce generates new request to database. Our plugin makes all manipulations with all objects inside Stored Procedures into MS SQL Server and gets all data in one request. It's important improvement.

Note.
Plugin will increase website page loading speed, but you must use only MSSQL Server. You can't go to another SQL databases. It's your payment for performance. You can see that each new version of NopCommerce increases its performance, but we try to make our plugin better too.

Note 2.
All customer who bought this plugin have been satisfied. If you have new ideas how to improve this plugin we can do them. You can download and try this plugin without any restrictions. 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 and your nopcommerce versions. Try plugin before purchase free.
Read customer's reviews about plugin and install trial version and try.
It will be the best benchmark (your nop store and your data).

I have additive service Custom Performance Optimisation

Plugin works ONLY with MS SQL Server and Azure.

Specification

Supported nopCommerce 4.20, 4.10, 4.00, 3.90, 3.80, 3.70, 3.60, 3.50, 3.40, 3.30, 3.20

Fully localizable using extermal XML files

Multi-store support

Free Trial (50 products will be updated)

1 year free support and upgrades since purchase date

Performance optimization

Easy setup and customization

Fast support

About US

We did more than 80 plugins for nopcommerce during last three years. Check out portfolio.

 

Reviews
Minor performance improvements
neokiller62
12/17/2018 8:00 AM
We made some tests with several websites based on NopCommerce 3.90
Results depends theme used by website (some themes performances are better with this plugin and some are not). We recommend to test the plugin before to buy it.

Bellow find detailed results:

Plugin version: 5.11

Plugin settings are:
Enable MSSQL Provider = ON
Ignore discounts (for catalogue only) = ON
Default Product Sorting = Name Asc
Always load products for SpeedFilter Plugin = OFF
Hide standard filter box = ON
Prepare specification attributes (category pages) = OFF (no specs in website)
Use optimization for PriceCalculationService = ON
Load all categories on startup = OFF
Load all manufacturers on startup = OFF
the test page is called 5 (five) times before we Google PageSpeed function is called (so no any compilation/load issues)

Result Website 1 (core theme) | plugin disable | only Google ips are allowed other IP are filtered for this test
First Contentful Paint 1.3 s
Speed Index 4.9 s
Time to Interactive 1.3 s
First Meaningful Paint 1.3 s
First CPU Idle 1.3 s
Estimated Input Latency 10 ms

Website 1 | plugin enabled | only Google ips are allowed other IP are filtered for this test
First Contentful Paint 1.3 s
Speed Index 4.9 s
Time to Interactive 1.5 s
First Meaningful Paint 1.3 s
First CPU Idle 1.3 s
Estimated Input Latency 10 ms

Result Website 2 (nopelectro theme) | plugin disable | only Google ips are allowed other IP are filtered for this test
First Contentful Paint 1.2 s
Speed Index 2.4 s
Time to Interactive 1.4 s
First Meaningful Paint 1.3 s
First CPU Idle 1.3 s
Estimated Input Latency 10 ms

Website 2 | plugin enabled | only Google ips are allowed other IP are filtered for this test
First Contentful Paint 1.2 s
Speed Index 2.1 s
Time to Interactive 1.3 s
First Meaningful Paint 1.3 s
First CPU Idle 1.3 s
Estimated Input Latency 10 ms

Result Website 3 (noproot theme) | plugin disable | only Google ips are allowed other IP are filtered for this test
First Contentful Paint 1.2 s
Speed Index 5.0 s
Time to Interactive 1.3 s
First Meaningful Paint 1.2 s
First CPU Idle 1.2 s
Estimated Input Latency 10 ms

Website 3 | plugin enabled | only Google ips are allowed other IP are filtered for this test
First Contentful Paint 1.2 s
Speed Index 4.2 s
Time to Interactive 1.3 s
First Meaningful Paint 1.2 s
First CPU Idle 1.2 s
Estimated Input Latency 10 ms

We were expecting more performance improvements so we are mitigated.
Autotuning feature would be a good thing (based on last process results)
Hope it will be better with new plugin versions
Was this review helpful? Yes  No (0 / 0)
A vendor responded to this review
Thank you for this test. I tested plugin and performance only using internal nopcommerce (plugin) methods. You can enable debugging and check the time of running of each method. I paid attention to working with database, but I can change something in ASP.NET too. Thank you for idea.
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
Gerard
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)
Excellent!
MasonRow
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
gela13
11/3/2016 7:29 AM
I'm very happy, my site is very fast now :-)
Check it on http://www.prigoza.be

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
ahsanmuneer
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!
AxiomaX
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
kilitsiz
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
jamesg
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
yatin11
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!
yatin11
1/27/2014 9:35 AM
Hi

I was trying to configure the plugin but showing this error.

http://tinypic.com/r/68hkxd/5
Was this review helpful? Yes  No (0 / 1)
Very Impressed
CorsaMeccanica
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
bipin
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)
eCommerce CONFERENCE 2019
Learn more