MSSQL Provider V2. Performance Optimization.

7 years ago
How to keep this plugin from reverting back to EF after 30 days?
7 years ago
You must enter a serial number.
7 years ago
I see a slight improvement in speed after installing this plugin.  Also my site used to crash a lot due to timeouts.  It's not doing that any more....not sure if it's because of the plugin or of the little tuning I did on IIS :)  Any way, good job.  How do I get the special number?
7 years ago
Send me in PM your site name.
7 years ago
Got the serial #.  Thanks so much.
6 years ago
We finally decided to use this plugin, response time is very cool and resource utilization is only around 10% of what we were earlier having. Their support is fantastic too... highly recommended.

I liked your plugin too, but didn't actually seen an improvement in performance.
6 years ago
bipin
Do you work in that company? :)
6 years ago
foxnetsoft wrote:
bipin
Do you work in that company? :)

Looks so according to his other forum posts and reviews

WARNING: bipin and jariwalakrunal, please stop posting such "promo" posts. Please also stop using bipin account for "voting up" posts of your other accounts and colleagues.
6 years ago
add fix from this link
https://www.nopcommerce.com/boards/t/25483/fix-very-important-speed-improvement.aspx
6 years ago
We have made a very significant improvement in the speed of loading pages.
For sites with a standard menu.
Increased speed of creating a tree group more than 10 times
Free update.
You can Enable
Catalog settings-Show the number of distinct products besides each category
and
Catalog settings-Include subcategories (number of distinct products)
Page loading speed will be high

1.       Uninstall current sql provider plugin.
2.       Replace with new plugin from the archive provided.
3.       Restart site.
4.       Install plugin.
5.       Update the Html.Action in the cshtml files (read below).


Very important!!!
To increase the speed of loading pages, replace the code in the files:
_ColumnsThree.cshtml, _ColumnsTwo.cshtml
Old code
@Html.Action("CategoryNavigation", "Catalog", new { currentCategoryId = currentCategoryId, currentProductId = currentProductId })

New Code
@Html.Action("MSSQLCategoryNavigation", "MSSQLCatalog", new { currentCategoryId = currentCategoryId, currentProductId = currentProductId })


Index.Mobile.cshtml
Old code
@Html.Action("CategoryNavigation", "Catalog", new { currentCategoryId = 0, currentProductId = 0 })

New Code
@Html.Action("MSSQLCategoryNavigation", "MSSQLCatalog", new { currentCategoryId = 0, currentProductId = 0 })