MSSQL Provider V2. Performance Optimization.

How to keep this plugin from reverting back to EF after 30 days?

You must enter a serial number.

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?

Send me in PM your site name.

Got the serial #.  Thanks so much.

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.

bipin
Do you work in that company? :)

foxnetsoft wrote:
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.

add fix from this link
https://www.nopcommerce.com/boards/t/25483/fix-very-important-speed-improvement.aspx

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 })