How to check performance of WordPress dashboard

From a very high level, off the top of my head these are the main things that contribute to how long it takes to load a page in the dashboard in WordPress:

  1. Application processing: PHP/Apache doing work
  2. Database processing: PHP calling MySQL and the time for queries to run
  3. External services – calling external API’s from the browser or server, waiting for data to come back
  4. Network/loading time overhead. Waiting for the page to come to your browser, downloading other dependencies like .js and .css

Query Monitor and the Network tab in your browser dev tools are good basic tools here to focus in on which of these is your main concern. It’s 90% likely that most of the time is spent in the database, but that’s not always the case. Maybe a plugin does something stupid and counts up all 50,000 orders using inefficient PHP on every page load.

But you need to find out where the time is spent first – either focus in on database queries and see if it’s those or not. Your point ‘measurements of loading time differ too much between page loads’ smells a lot to me like it points to a problem – might be worth updating your question with high level numbers from QM, particularly time spent on database queries, and any other big variances you notice in any other numbers.

Also getting familiar with server load tools will be useful – at the least what does top/htop show you for server load, memory usage, which processes are busy, etc. What does this look like when your site feels fast compared to when it feels slow?

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)