Hi, I installed nopAccelerate on the default nopCommerce 3.1 website (including the 51 demo products). I enabled the nopCommerce setting 'Show the number of distinct products besides each category' (including subcategories), so I get the nice facets for categories.
When I restart the nopCommerce website (incl. recycling of app-pool) and visit the url "http://localhost/computer", I noticed that 196 select-queries are sent to Solr. Apparently most of these queries are for getting the number of products for each category. However, there seem to be a lot of identical (and unnecessary) queries fired to Solr.
Is this a bug in nopAccelerate or in nopCommerce?
See below for the list of 196 queries on visiting a page after the website restarted:
This query is being made to fetch the product count for each category. The result is then cached for saving further calls.
Moreover, you're right. This seems to be a bug as there seems to be a lot of identical queries being made to Solr which is not necessary. An appropriate issue is created and we'll fix it on urgent basis.
The latest version 2.7 with nopcommerce 3.5 appears to have a performance problem on category pages or anywhere SolrProductController.CategoryNavigation is used.
I have used miniprofiler to detect that particular controller action causes a significant delay in page loads (5 - 10 seconds). If I comment out the action from the parent view page loads fall in line with expectations.
I have checked the performance of nopAccelerate version 2.7 with nopCommerce version 3.50 and it gives better performance. Can you please provide us some more details? On which page it took more time to load or any page URL. So, we can check and respond you.
Hello. Can you help with this? The specified LINQ expression contains references to queries that are associated with different contexts System.NotSupportedException: The specified LINQ expression contains references to queries that are associated with different contexts. ... XcellenceIT.Plugin.Solr.Core.SolrCoreService.GetAssociatedLanguageByStoreId(Int32 sId) at XcellenceIT.Plugin.Solr.Core.SolrCoreService.StartScheduleTasks() at XcellenceIT.Plugin.Solr.Core.Services.SolrScheduleTask.Execute()