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 Events Calendar Widget

By Common Ninja

Events CalendarTry 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.

Events Calendar for nopCommerce logo

Events Calendar

Add an events calendar to your site so visitors can view upcoming activities, improving engagement and event visibility.

RSS Feed Carousel for nopCommerce logo

RSS Feed Carousel

Show RSS content with an RSS feed carousel that updates automatically, displays posts in a smooth scrolling layout, and keeps visitors engaged.

Process for nopCommerce logo

Process

Use a process widget to present tasks in a clear visual sequence, showing each step with images and text to improve understanding and user engagement.

Website Translator for nopCommerce logo

Website Translator

Add a translation widget to your site so users can switch languages easily and access content in their preferred language.

HIPAA Compliance Forms for nopCommerce logo

HIPAA Compliance Forms

Create secure HIPAA compliant forms that protect sensitive data, offer full customization, and integrate easily for safe medical information collection.

Job Application Form for nopCommerce logo

Job Application Form

Collect candidate information with a job application form that organizes submissions, streamlines hiring, and helps you manage applicants efficiently.

QR Code for nopCommerce logo

QR Code

Use the QR Code Generator to create and display QR codes for URLs, contact info, downloads, locations, and more.

Feature Voting for nopCommerce logo

Feature Voting

Use feature voting so users submit ideas, vote on requests, and help you prioritize product updates by real customer demand.

Card Builder for nopCommerce logo

Card Builder

Add customizable content cards to your site to display structured information clearly with flexible layout and design options.

Support Form for nopCommerce logo

Support Form

Use a support form that lets customers submit tickets, saves each request, sends notifications, and helps you manage support more efficiently.

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.

RSS Feed for nopCommerce logo

RSS Feed

Show fresh content from any source with an RSS feed that keeps your site updated, improves navigation, and boosts user engagement.

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