nop 4.40.4 - TimeOuts in Admin Dashboard's BestsellersBriefReports

11 months ago
Hi Could you provide a backup copy of your database to analyze the problem? If you have such an opportunity, please send me a link in the PM

mfitconsultants wrote:
We are encountering the same timeout issue after updating to 4.6.2

So we are now not able to access the admin area

Can you advise on how we can remove redudant products or increase the speed of response?

I have followed this guide -

https://www.nopcommerce.com/en/blog/nopcommerce-performance-guide

but still have the same issue
Interested in the dedicated Premium support services provided by core developers? Please visit https://www.nopcommerce.com/nopcommerce-premium-support-services

Regards,
Sergey Koshelev
0
11 months ago
mfitconsultants wrote:
We are encountering the same timeout issue after updating to 4.6.2

So we are now not able to access the admin area

Can you advise on how we can remove redudant products or increase the speed of response?

I have followed this guide -

https://www.nopcommerce.com/en/blog/nopcommerce-performance-guide

but still have the same issue



What steps have you taken to upgrade database and website to the nopCommerce 4.60.2?
Please upvote the answer if it helps :)

Need any professional assistance? Drop us your requirements on [email protected]
To connect on Skype, please use this url  https://join.skype.com/invite/cEc85R17Qw2V

https://nopadvance.com
Your PERFECT nopCommerce GOLD Solution Partner
0
2 months ago
I got the same issue and the only solution was by disable  Bestsellers by quantity and  Bestsellers by amount reports from loading on the dashboard.
I have 120K orders and 1200 products.
I am using azure web app with sql server. The issue use 100% of the sql sever which i have standard sql server with 250 DTU.
Any other suggestion without removing this 2 reports?
1
2 months ago
Hosam.Bedawy wrote:
...Any other suggestion without removing this 2 reports?


Profile the SQL Server Query
https://learn.microsoft.com/en-us/sql/relational-databases/extended-events/quick-start-extended-events-in-sql-server?view=sql-server-ver16
(Maybe you can add indexes to increase performance.)
www.noptools.com
1