MS SQL Provider performance optimization (foxnetsoft.com)

MS SQL Provider performance optimization (foxnetsoft.com)
3.6 17
Plugin to speed up website performance. Performance Optimization.
2021-04-02T11:40:36.4360257Z
$60.00
Get extension You will be re-directed to the developer's website to download this plugin
Supported versions: 3.90 , 4.00 , 4.10 , 4.20
Created: April 26,2013
Last updated: February 01,2020
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 90 plugins for nopcommerce during last three years. Check out portfolio.

Reviews
mehdin69 9/12/2019 12:06 AM
error on nop 4.2
Better not to accuse me
Take a test once
After deleting this plugin the problem was solved
Was this review helpful? Yes0 / No1
mehdin69 9/12/2019 12:05 AM
error on nop 4.2
You can see some of my posts below

https://www.nopcommerce.com/p/3111/google-accelerated-mobile-for-nopcommerce-nopplugincom.aspx

https://www.nopcommerce.com/p/3111/google-accelerated-mobile-for-nopcommerce-nopplugincom.aspx

https://www.nopcommerce.com/p/2511/affiliate-program-standard-platinum-and-ultimate-thenopplugins.aspx

https://www.nopcommerce.com/p/4793/progressive-web-app-pwa.aspx
Was this review helpful? Yes0 / No0
mehdin69 9/11/2019 3:49 PM
error on nop 4.2
After installation
If we set the Product Attributes for the commodity
The product is not displayed on the site and the site is in error....
Was this review helpful? Yes0 / No0
A manager responded to this review
Plugin doesn't change the logic for working with product attributes.
Maybe you have the problem in another place.
Are you a fake :)? You have only one post at nop forum.
neokiller62 12/17/2018 8:00 AM
Minor performance improvements
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? Yes1 / No0
A manager 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.
[email protected] 8/7/2018 8:11 PM
Want speed?
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? Yes0 / No0
[email protected] 7/14/2017 3:13 AM
Perfect Support!
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? Yes0 / No0
Gerard 4/29/2017 12:42 AM
Very useful
The speed in multistore and acl list settings are amazing.
And the service is great
Was this review helpful? Yes0 / No0
MasonRow 12/5/2016 9:00 AM
Excellent!
Wish I had found this long ago. What a difference this made for our site! Highly recommended.
Was this review helpful? Yes0 / No0
gela13 11/3/2016 7:29 AM
Performance & service
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? Yes0 / No0
ahsanmuneer 3/18/2015 5:08 AM
Great plugin to improve the speed for nopCommerce
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? Yes0 / No0
AxiomaX 2/26/2015 5:58 AM
Our store with Fox plugins flyy!
Our store with Fox plugins are faster than ever and the support is more than amazing!!!
Was this review helpful? Yes0 / No0
kilitsiz 2/25/2015 2:35 AM
That thing deserves a medal
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? Yes0 / No0
jamesg 10/16/2014 3:25 AM
Definate increase in speed
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? Yes0 / No0
yatin11 1/29/2014 3:40 AM
Still not workinng
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? Yes1 / No0
yatin11 1/27/2014 9:35 AM
Not allowing to configure!
Hi

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

http://tinypic.com/r/68hkxd/5
Was this review helpful? Yes0 / No1
CorsaMeccanica 9/14/2013 1:03 AM
Very Impressed
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? Yes2 / No0
bipin 6/26/2013 6:50 AM
not working
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? Yes1 / No3