Skip Navigation

[Resolved] Very long database queries

This support ticket is created 6 years, 8 months ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun Mon Tue Wed Thu Fri Sat
- 7:00 – 14:00 7:00 – 14:00 7:00 – 14:00 7:00 – 14:00 7:00 – 14:00 -
- 15:00 – 16:00 15:00 – 16:00 15:00 – 16:00 15:00 – 16:00 15:00 – 16:00 -

Supporter timezone: Europe/London (GMT+00:00)

Tagged: 

This topic contains 3 replies, has 2 voices.

Last updated by Nigel 6 years, 8 months ago.

Assisted by: Nigel.

Author
Posts
#626788
Screen Shot 2018-03-20 at 7.55w.png

I had a problem with speed in my administration area and the WPEngine technician pointed out a very long query instigated by the Types plugin, image attached. He also said the following:

What I did find was that, the screenshot I posted a bit ago is related to the Types plugin you have. I recommend getting with that plugin developer to see if any queries can be optimized. The plugin was trying to do:

SELECT * FROM wp_postmeta WHERE post_id IN(ID)

Replace ID with the number seen from screenshot (which is quite a few)

#626911

Nigel
Supporter

Languages: English (English ) Spanish (Español )

Timezone: Europe/London (GMT+00:00)

Hi Eldred

Where is this query being generated?

What page are you on and what content is on the page?

#627146

Hi Nigel. I was navigating around the admin area, mainly between pages and it was incredibly slow. The technician spotted one plugin that I have disabled (not one of yours) that was continuously hitting the database even when it wasn't being utilised, and then identified this issue. I can give you access if you want to look

#628400

Nigel
Supporter

Languages: English (English ) Spanish (Español )

Timezone: Europe/London (GMT+00:00)

Hi Eldred

Sorry for the delay getting back to you, the queue has been extremely busy.

I thought I had a copy of your site already but see I do not, so can I set the private reply up to get those from you.

Thanks