Order List -> Sql Server Timeout

Hi!

We are using nopcommerce 3.7, with almost 5K products and 100 categories, 100K orders and we are facing some sql server timeout under order list view. Orders are not loaded sometimes.

Have you faced it before?

Adding this index could help:

CREATE NONCLUSTERED INDEX IX_CREATEDONUTC ON dbo.[Order] (CreatedOnUtc DESC)

Yes, that is true.. Thanks.

Nop 3.7 has some index problems.

I have add follow too:

CREATE NONCLUSTERED INDEX [IX_ProductCategory_DisplayOrder] ON [dbo].[Product_Category_Mapping] ([DisplayOrder] ASC)
CREATE NONCLUSTERED INDEX [IX_ProductPicture_DisplayOrder] ON [dbo].[Product_Picture_Mapping] ([DisplayOrder] ASC)
CREATE NONCLUSTERED INDEX [IX_Product_Manufacturer_Mapping_ProductId] ON [dbo].[Product_Manufacturer_Mapping] ([ProductId] ASC)
CREATE NONCLUSTERED INDEX [IX_Product_Manufacturer_Mapping_ManufacturerId] ON [dbo].[Product_Manufacturer_Mapping] ([ManufacturerId] ASC)
CREATE NONCLUSTERED INDEX [IX_Product_Manufacturer_Mapping_IsFeaturedProduct] ON [dbo].[Product_Manufacturer_Mapping] ([IsFeaturedProduct] ASC)
CREATE NONCLUSTERED INDEX [IX_Product_Category_Mapping_IsFeaturedProduct] ON [dbo].[Product_Category_Mapping] ([IsFeaturedProduct] ASC)
CREATE NONCLUSTERED INDEX [IX_Product_Category_Mapping_CategoryId] ON [dbo].[Product_Category_Mapping] ([CategoryId] ASC)
CREATE NONCLUSTERED INDEX [IX_Customer_CustomerRole_Mapping_Customer_Id] ON [dbo].[Customer_CustomerRole_Mapping] ([Customer_Id] ASC)
CREATE NONCLUSTERED INDEX [IX_ShoppingCartItem_CustomerId] ON [dbo].[ShoppingCartItem] ([CustomerId] ASC)
CREATE NONCLUSTERED INDEX [IX_Product_Picture_Mapping_ProductId] ON [dbo].[Product_Picture_Mapping] ([ProductId] ASC)
CREATE NONCLUSTERED INDEX [IX_Product_Deleted] ON [dbo].[Product] ([Deleted] ASC)

Any other you would suggest?