number of products shown by each category

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.

Thanks,


jack

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.