Is there an easy way to detect complex querries in WordPress that draw down the site speed?

Server Administration ForumIs there an easy way to detect complex querries in WordPress that draw down the site speed?
corona_max asked 3 weeks ago PPU : 10

I want to scale up my Linux Ubuntu WordPress installation. Therefore I would like to eleiminate some complex querries done by plugins. Is there an easy way on how to detect these plugis that cause a lot of pomputation power for my server?




1 Answers
On_God answered 1 week ago

Yes, there is an easy way to find out the queries that are slowing your site down.

But before I start, I’ll like to remind you that complex queries are not the only reason why a site’s speed is slow.

It could be that your site is getting too old (more than 2years old). Or worse, that your site’s database (MySQL for WordPress) wasn’t properly formed.

However, if you’re sure that queries are the problem, then here are some solutions for you.

Due to technology and its advancement, a lot of tools have been provided to help you figure out which queries and their respective functions slowing your site’s speed.

Below is a concise list of those tools (plugins).

Debug bar: this is the most trusted and possibly the most popular plugin for what you need. When used, it will display a list that shows all files and functions that bring about queries. From this list, you can detect which queries are slow or complex (usually those at the bottom of the list), which function they carry out and what exactly is causing the delay.

However, you need to be careful while using this plugin. This is because it could cause problems in your website if used in a production server. You can enable the SAVEQUERIES in your site to guard against its damage.

Query monitor: this plugin is similar to the Debug bar because it shows the origin of the queries. However, unlike the former where you have to guess or figure out the slow or complex plugins, it specifically shows this by making the said queries in red.

NewRelic: this plugin displays slow queries when you upgrade to their paid version. They are, however, more cumbersome and complex than their counterparts. This is to say that you need in-depth programming knowledge to understand the results that they will display after searching and finding slow queries in your site.

The list that the NewRelic will display will contain detailed code features, down to the number of milliseconds that each query and function spent.

Let me know if you have any more questions.