Skip Navigation

[Escalated to 2nd Tier] very slow query when toolset is activated

This support ticket is created 3 years, 11 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.

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
- 10:00 – 13:00 10:00 – 13:00 10:00 – 13:00 10:00 – 13:00 10:00 – 13:00 -
- 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 -

Supporter timezone: Asia/Kolkata (GMT+05:30)

Tagged: 

This topic contains 8 replies, has 3 voices.

Last updated by Minesh 3 years, 9 months ago.

Assisted by: Minesh.

Author
Posts
#1883589
slowquery.png

I am experiencing a very slow query when Toolset is activated, along with WP Offload Media. The slow query only happens when Toolset is activated.

I have installed Query monitor and according to that plugin there is a conflict with post meta with a meta key of "_wp_attached_file" and a value that has a .tmp file name. WP Offload Media is responding to the "wp_unique_filename" filter call to ensure that it has not offloaded something that could have a name clash with the newly proposed file name.

Screenshot attached of the query

#1884051

Nigel
Supporter

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

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

It's not obvious from your screenshot what role Types is playing there.

Post meta queries are notoriously slow, but, still, over 2.5s is very high for such a relatively simple query.

Just how big is your database? Specifically, how many rows does wp_postmeta have?

If you perform the same queries directly in phpMyAdmin how long do they take? (You can copy and paste the same SQL query.)

#1884745
SQL-command-Adminer.png

WE have over 1 million rows, however this slow query goes away when I deactivate Toolset Types.

There are no results when i perform the query in the db.

It seems there is something stored in Toolset tables that initiates this query . Is there a way to check that?

#1884947
Desktop-screenshot.png
Desktop-screenshot (1).png

I found that this file: types\vendor\otgs\installer\includes\class-installer-dependencies.php contains code that is part of the problem with the slow query. When I comment out the code in the attached screenshot, it is no longer included in the slow queries in query monitor and the admin is much faster. Can you explain what this piece of code does and why it is trying to delete a file that does not exist?

#1885089

Minesh
Supporter

Languages: English (English )

Timezone: Asia/Kolkata (GMT+05:30)

I shared the valuable information you shared with our Devs and they found there is indeed something to investigate further.

I've escalated this to our Devs and they will investigate further.

I'll get in touch with you as soon as I know more. Please hold on further updates.

#1885101

awesome thanks!

#1885115

Minesh
Supporter

Languages: English (English )

Timezone: Asia/Kolkata (GMT+05:30)

Changing status of the ticket.

#1949453

This remains a problem still for version 3.4.7. Any updates on this?

#1950777

Minesh
Supporter

Languages: English (English )

Timezone: Asia/Kolkata (GMT+05:30)

I just checked with the internal ticket reported and there is no news yet to share with you.

But I had a talk with Dev and the update is that they will try to propose fix as soon as possible but there is no ETA on it. I'll get in touch with you as soon as I get any updates on it.