Skip Navigation

[Résolu] Very long database queries

This support ticket is created Il y a 6 années et 1 mois. 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.

No supporters are available to work today on Toolset forum. Feel free to create tickets and we will handle it as soon as we are online. Thank you for your understanding.

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+01:00)

Marqué : 

This topic contains 3 réponses, has 2 voix.

Last updated by Nigel Il y a 6 années et 1 mois.

Assisted by: Nigel.

Auteur
Publications
#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: Anglais (English ) Espagnol (Español )

Timezone: Europe/London (GMT+01: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: Anglais (English ) Espagnol (Español )

Timezone: Europe/London (GMT+01: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

This ticket is now closed. If you're a WPML client and need related help, please open a new support ticket.