Performance problem

Posted: November 14, 2017 at 4:23 PM Quote #196176
Hello

We have huge problem with performance on a very small nopCpmmerce 3.00 website(5000 products). Pages are not loading at all, page load can be few minutes, a lot of timeout errors in the log, I know that the first thought is to check database connection and it's working, the database connection isn't a problem we are sure.

Miniprofiler doesn't show what methods cause the problem, and I don't know where to start.

What can it be? Where should we look?

Thanks

Alex
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Umbraco MVP
Posted: November 14, 2017 at 10:54 PM Quote #196182
Hi,

Use fiddler(free resource) to monitor what exactly blocking your page from loading

https://www.telerik.com/fiddler
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Monish Rafi Siddiqui
Posted: November 15, 2017 at 3:04 AM Quote #196197
I know that server responds slowly, how fiddler can help?
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Umbraco MVP
Posted: November 15, 2017 at 3:11 AM Quote #196199
in case you are saying that DB connection is fine and only pages loads slowly then test with fiddler to analyze which page or script is creating much load

before this try below steps as may be your issue will be resolved

1. Clear the log file of your SQL DB
2. Clear the Cache of nop store and check the system logs again to find any errors

Thanks
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Monish Rafi Siddiqui
Posted: November 15, 2017 at 3:13 AM Quote #196200
DB connection is fine, but site responds very slowly, it's not front-end problem definitely, something with settigs server or database

I did clear cache and restart app, how can I clean up site database from log entries?

Maybe some other scripts?
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Umbraco MVP
Posted: November 15, 2017 at 3:24 AM Quote #196202
follow below steps for SQL db maintenance

Go-to you SQL database management studio-click on properties by selecting database-Files and check log file size

if the file size is much heavy then needed to clear and generate new one

also check that log file has been set to auto-grow and your disk space where your database file resides

Follow steps mentioned on Microsoft tech net to clear log files

https://docs.microsoft.com/en-us/sql/relational-databases/databases/delete-data-or-log-files-from-a-database
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Monish Rafi Siddiqui
Premium support services
  • Dedicated premium support services provided by core developers are intended for persons who run mission critical websites, work on projects with tight deadlines, or want to get dedicated support.
Professional services
  • Want to open a new store? Want to take your store to the next level? Need a custom extension? We can customize nopCommerce to fit your store perfectly. Request a quote to get started.