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 Announcements Widget

By Common Ninja

AnnouncementsTry 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.

Announcements for nopCommerce logo

Announcements

Add announcements to your site to share important updates, keep visitors informed, and guide them toward actions that support engagement and conversions.

Event Flip Cards for nopCommerce logo

Event Flip Cards

Use event flip cards to highlight upcoming activities, improve visibility, and help visitors discover events that increase attendance and engagement.

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.

Sitejabber Reviews for nopCommerce logo

Sitejabber Reviews

Show Sitejabber reviews to build trust, strengthen credibility, and help visitors make confident purchase decisions that support higher sales.

March Madness Bracket Maker for nopCommerce logo

March Madness Bracket Maker

Create interactive March Madness brackets where users can make predictions, track tournament progress, and compete with others throughout every round.

Subscription Button for nopCommerce logo

Subscription Button

Use a subscription button to streamline recurring payments, simplify signup, and help increase conversions with seamless PayPal or Stripe integration.

Video Gallery for nopCommerce logo

Video Gallery

Showcase videos with a video gallery that organizes clips from multiple sources in clear visual layouts that keep visitors watching and support higher conversions.

Device Mockup for nopCommerce logo

Device Mockup

Show products, apps, or designs inside a clean device mockup that improves visualization, builds credibility, and helps visitors make confident decisions.

YouTube Slider for nopCommerce logo

YouTube Slider

Show YouTube videos with a YouTube slider that displays clips in a smooth, customizable layout to boost engagement.

Countdown to Download for nopCommerce logo

Countdown to Download

Use a countdown to download widget that reveals files after the timer ends, builds anticipation, and guides visitors toward higher engagement.

Lottie Player for nopCommerce logo

Lottie Player

Use a Lottie player to embed lightweight JSON animations that improve visual design, keep pages fast, and create a smoother user experience.

iMessage Conversation for nopCommerce logo

iMessage Conversation

Bring true-to-life iMessage threads to any page, rendered as real content instead of a screenshot.

More plugins

plugins You Might Like

Mollie Payment PluginMollie Payment Plugin

Mollie Payment Plugin

This plugin allows customers to pay via credit card and other methods using the Mollie Payment Gateway.

Discover plugin
Customer's requests 2.0 (foxnetsoft.com)Customer's requests 2.0 (foxnetsoft.com)

Customer's requests 2.0 (foxnetsoft.com)

This plugin is advanced version of our plugin Request For Quote with history of requests and new extra features.

Discover plugin
Stripe Express ConnectStripe Express Connect

Stripe Express Connect

Stripe Express Connect Plugin by Techgrains technologies. Express connect plugin is for US region only. Plugin includes to connect accounts for multiple vendors, split payment, refund.

Discover plugin
Discount Rules for Customer's Birthday by nopStationDiscount Rules for Customer's Birthday by nopStation

Discount Rules for Customer's Birthday by nopStation

This plugin allows you to configure discounts for customers' birthdays in your nopCommerce store.

Discover plugin
HDFC Payment PluginHDFC Payment Plugin

HDFC Payment Plugin

HDFC Payment Plugin provides facilities for online payment with HDFC bank in India. It facilitates online purchases from a merchant's website and helps them to collect payment from the end customers through net banking, credit and debit cards etc.

Discover plugin
Google Multi Language Sitemap (foxnetsoft.com)Google Multi Language Sitemap (foxnetsoft.com)

Google Multi Language Sitemap (foxnetsoft.com)

Plugin creates Google Multi Language Sitemap and adds 'hreflang' attribute.

Discover plugin
Klarna Checkout PaymentKlarna Checkout Payment

Klarna Checkout Payment

Fully featured Klarna Checkout plugin. Use as widget anywhere, or as standard payment method. Full Klarna back-office integration.

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

CMS Manager (foxnetsoft.com)

Add Content Management System features (add new HTML pages)

Discover plugin
Topic Export-Import by nopStationTopic Export-Import by nopStation

Topic Export-Import by nopStation

Topic Export-Import plugin for nopCommerce lets the store owner easily export/import topics straight from the admin panel with a simple click.

Discover plugin
Dmoney Payment by nopStationDmoney Payment by nopStation

Dmoney Payment by nopStation

This plugin enables Dmoney gateway payments.

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