I would like to ask you if anyone knows about a solution to the performance problem- every time the page loads its recursively calculate each category's number of products.
I recommended this index here https://www.nopcommerce.com/boards/t/10624/20-speedperformance-concerns.aspx?p=8
CREATE NONCLUSTERED INDEX [IX_ProductVariant_ProductId] ON [dbo].[ProductVariant] ([ProductId]) INCLUDE ([Price],[AvailableStartDateTimeUtc],[AvailableEndDateTimeUtc],[Published],[Deleted])
It was added to nop 2.10 (upgrade.sql), as were other performance enhancements.
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.