Using this plugin, you will increase your website’s page loading speed and boost your profits. The plugin enhances user-friendliness by allowing you to enable ACL (Access Control List) rules, set “limit per store” parameters, and display the number of distinct products within each category. As a result, you will avoid any performance degradation.

How does it work?

We have implemented three key improvements:

Improvement 1.

We have moved the logic for retrieving data into MS SQL Stored Procedures for handling complex queries. By default, NopCommerce uses Entity Framework to access databases. Entity Framework is a robust framework that allows developers to write code that is compatible with various databases (e.g., MS SQL Server, Oracle, MySQL). However, this versatility comes at a cost to performance.

Entity Framework generates C# commands (LINQ) to fetch products, categories, and other data, which are then converted into SQL commands (T-SQL). While Entity Framework generates efficient SQL code for simple queries, it may produce suboptimal code for more complex queries, especially those involving multiple tables and numerous conditions. This can result in performance issues, as Entity Framework sends these complex SQL commands to MS SQL Server. MS SQL Server then analyzes these commands and creates a query plan. For very complex queries, MS SQL Server might struggle with optimization.

We identified two main problem areas: the generation of SQL commands by Entity Framework and the execution of these commands in MS SQL Server. These issues are typically noticeable only with large databases and complex queries. To address these performance concerns, we replaced the standard data retrieval mechanism with manually written SQL commands embedded in MS SQL Stored Procedures. This approach allows MS SQL Server to optimize the query execution plan for each Stored Procedure, improving overall performance.

Improvement 2.

We aim to minimize the loading of excess data by filtering as much data as possible on the server side.

For example, if you need to load an order using a GUID, you may encounter performance issues with Entity Framework (EF) because it does not support casting GUIDs to strings. As a result, NopCommerce must read all orders to find the one with the specified GUID. In stores with a large number of orders, this can lead to significant delays.

To address this, our plugin optimizes data retrieval by ensuring that filtering is done efficiently on the server side, thus reducing the amount of data that needs to be processed and improving overall performance.

Improvement 3.

The category, manufacturer, and vendor pages have been rewritten for enhanced performance.

Previously, when a customer opened a category page, NopCommerce would read data for categories, breadcrumbs, featured products, and products from these categories through multiple database requests. Each group of objects—such as categories, breadcrumbs, and products—would trigger a separate request to the database.

Our plugin significantly improves this process by consolidating all data manipulations into a single request. It achieves this by performing all necessary operations within Stored Procedures on the MS SQL Server. This approach allows us to retrieve all required data with just one database request, resulting in a more efficient and faster-loading page.

Note:
The plugin is designed to enhance website page loading speed but is compatible exclusively with MS SQL Server. This performance boost comes with the trade-off of limiting compatibility to this specific SQL database. While each new version of NopCommerce continues to improve in performance, we are also committed to enhancing our plugin accordingly.

Note 2:
All customers who have purchased this plugin have reported high levels of satisfaction. If you have suggestions for new features or improvements, we are open to incorporating them. You can download and test the plugin without any restrictions. The unregistered version is fully operational, with only one limitation: a 30-day trial period. After this period, the plugin will be disabled.

How much does the speed increase?
The increase in speed depends on the size of your data and the version of NopCommerce you are using. The exact performance gain can vary based on these factors.

Try before you buy:
We recommend testing the plugin before making a purchase. You can download the trial version to see how it performs with your specific NopCommerce store and data. This will provide the best benchmark for your situation.

Customer reviews:
We encourage you to read customer reviews about the plugin to understand its effectiveness. Installing and testing the trial version will give you firsthand experience of the performance improvements.

we have an additive service Custom Performance Optimisation

Plugin works ONLY with MS SQL Server and Azure.

Compatible for NopCommerce 4.20, 4.10, 4.00, 3.90, 3.80, 3.70, 3.60, 3.50, 3.40, 3.30, 3.20.

How to Install and Configure plugin.