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 Sticky Video Widget

By Common Ninja

Sticky VideoTry 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.

Sticky Video for nopCommerce logo

Sticky Video

Use a sticky video that stays visible while users scroll to keep content in view, increase watch time, and boost engagement.

Visitor Counter for nopCommerce logo

Visitor Counter

Show real time visitor counts with a visitor counter widget that displays live traffic, builds social proof, and boosts engagement.

Pomodoro Timer for nopCommerce logo

Pomodoro Timer

Add a Pomodoro timer to your site so users can structure focus and break cycles, improving time management and productivity.

AI Chatbot for nopCommerce logo

AI Chatbot

Add an AI chatbot that answers user questions by crawling your site, using uploaded content, and collecting chat interactions.

Image Poll for nopCommerce logo

Image Poll

Create interactive image polls that use compelling visuals to boost engagement, gather feedback, and help visitors vote easily.

Restaurant Menu Flip Cards for nopCommerce logo

Restaurant Menu Flip Cards

Present dishes with restaurant menu flip cards that highlight key details, help visitors explore options easily, and support confident ordering decisions.

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.

Popup Builder for nopCommerce logo

Popup Builder

Add customizable popups to your site to capture attention, deliver messages, and drive actions like signups or conversions.

TikTok Carousel for nopCommerce logo

TikTok Carousel

Show TikTok videos with a TikTok carousel that arranges clips in a smooth, customizable layout to boost engagement and keep visitors watching.

Vimeo Slider for nopCommerce logo

Vimeo Slider

Show Vimeo videos with a Vimeo slider that displays clips in a smooth slider to boost engagement and keep visitors watching.

Countdown for nopCommerce logo

Countdown

Add a countdown timer to your site to highlight upcoming events or launches and encourage timely user action.

PayPal Donate Button for nopCommerce logo

PayPal Donate Button

Make it easy for supporters to contribute using PayPal or Stripe by adding a donation button that keeps giving fast, secure, and on site.

More plugins

plugins You Might Like

Merge Guest Orders by nopStationMerge Guest Orders by nopStation

Merge Guest Orders by nopStation

Merge Guest Order plugin provides a feature to merge the guest orders if the customer will register with same e-mail.

Discover plugin
Myob Essentials Integration (Atluz)Myob Essentials Integration (Atluz)

Myob Essentials Integration (Atluz)

Myob Essentials Integration to automate creation of invoice and payment with discounts, reward points, gift cards, customer details and country specific tax.

Discover plugin
Print Shipping Labels (Avery, Zebra) (foxnetsoft.com)Print Shipping Labels (Avery, Zebra) (foxnetsoft.com)

Print Shipping Labels (Avery, Zebra) (foxnetsoft.com)

Print shipping labels on labels printers (Avery, Zebra, Dymo, etc.)

Discover plugin
Import Manager (foxnetsoft.com)Import Manager (foxnetsoft.com)

Import Manager (foxnetsoft.com)

Create and update properties of products, categories, manufactures, create pictures, localized values, etc. using external CSV, XLSX, TXT files.

Discover plugin
Product GrowthProduct Growth

Product Growth

This Plugin performs automated pricing analysis of products.

Discover plugin
Afterpay Payment by nopStationAfterpay Payment by nopStation

Afterpay Payment by nopStation

This plugin allows customers to pay using Afterpay payment gateway.

Discover plugin
"Has all products" discount requirement rule"Has all products" discount requirement rule

"Has all products" discount requirement rule

This plugin allows to enable "Has all products" discount requirement rule in your store.

Discover plugin
nopWatermarknopWatermark

nopWatermark

This plugin dynamically adds watermarks (text or picture) to the store pictures (Products, Categories, Manufacturers) without changing the original images. This plugin also supports a multi-store configuration.

Discover plugin
SQL Manager (MSSQL) by nopStationSQL Manager (MSSQL) by nopStation

SQL Manager (MSSQL) by nopStation

This plugin allows to view/create SQL reports from admin panel.

Discover plugin
Mobile authentication + Sms notificationMobile authentication + Sms notification

Mobile authentication + Sms notification

Users may not have access to their email many times, but mobile is always available. By integrating the plugin with a message service provider, you can have a fast, safe, and user-friendly way to log in!

Discover plugin

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