MS SQL Provider performance optimization (foxnetsoft.com)

MS SQL Provider performance optimization (foxnetsoft.com)

nopCommerce plugin

Install on nopCommerce

App Details

MSSQL Provider V2 (Performance) Plugin to speed up website performance (Performance Optimization) (FOXNETSOFT.COM) Buy now Documentation Another plugins Performance optimisation 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.

Pricing

Starting from $60 per month.

Check Out the Instagram Feed Widget

By Common Ninja

Instagram FeedTry For Free!

App Info

Rating

Reviewers

18 reviews

Tags

No tags

Developed By

foxnetsoft

Common Ninja Apps

Some of the best Common Ninja plugins for nopCommerce

Browse our extensive collection of compatible plugins, and easily embed them on any website, blog, online store, e-commerce platform, or site builder.

Instagram Feed for nopCommerce logo

Instagram Feed

Show Instagram posts in a live feed that keeps content fresh, builds social proof, and helps visitors engage with your brand.

Flip Cards for nopCommerce logo

Flip Cards

Use flip cards to present information interactively, improve visual design, and guide visitors toward clearer decisions that support conversions.

Scroll to Top for nopCommerce logo

Scroll to Top

A scroll to top button that helps visitors move back to the top of long pages quickly, improving navigation and overall browsing flow.

X Feed for nopCommerce logo

X Feed

Show posts in an X feed that keeps updates visible, improves content discovery, and helps visitors stay engaged with your latest activity.

Payment Method Logos for nopCommerce logo

Payment Method Logos

Show payment method logos that highlight accepted payment options, build trust at checkout, and help visitors feel confident completing their purchase.

Pricing Slider for nopCommerce logo

Pricing Slider

Use a pricing slider to show dynamic prices by quantity, help visitors compare options, and support confident purchases.

Cookie Banner for nopCommerce logo

Cookie Banner

Use a Cookie Banner to inform visitors about cookies on your site and let them manage their consent in a clear, structured way.

Image Hover Effects for nopCommerce logo

Image Hover Effects

Use image hover effects to add animations, highlight key visuals, and keep visitors engaged with dynamic image reveals.

Live Weather Forecast for nopCommerce logo

Live Weather Forecast

Use a live weather forecast widget to show current conditions and upcoming predictions, giving visitors real time local weather updates for better planning.

Logo Slider for nopCommerce logo

Logo Slider

Add a logo slider to your site to showcase clients and partners, strengthen brand credibility, and build trust with new visitors.

Order Form for nopCommerce logo

Order Form

Use an order form to let customers submit product orders, save entries, receive notifications, and collect payments through PayPal or Stripe for a smoother buying experience.

Real Estate Listings for nopCommerce logo

Real Estate Listings

Create real estate listings with a listings widget that displays properties clearly, supports customization, and helps visitors explore homes more easily.

More plugins

plugins You Might Like

Discover Apps By Platform

Discover the best apps for your website

WordPress
Wix
Shopify
Weebly
Webflow
Joomla
PrestaShop
Shift4Shop
WebsiteX5
MODX
Opencart
NopCommerce

Common Ninja Search Engine

The Common Ninja Search Engine platform helps website builders find the best site widgets, apps, plugins, tools, add-ons, and extensions! Compatible with all major website building platforms - big or small - and updated regularly, our Search Engine tool provides you with the business tools your site needs!

Multiple platforms