Plugin slows down WordPress Customize

Hello,

“my hosting has told me that it’s you plugin” – what else your hosting told? Logs? Slow MySQL queries? Something else?

Please provide some useful info.

As this is first time we got such request I suppose this is conflict with some other plugin. You could try to turn off other plugins 1 by 1 and check when the Customize will work ok.

Regards,
Dmytro

This is what they told me:

`Hello,

Thank you for getting back to us.

We have reproduced the error from our side and it appears that the timeout occurs due to a long-running database query:
SELECT autoload FROM wplx_options WHERE option_name = ‘_transient_berocket_alphabet_brand_widget-REP

The query is running for too long, which causes the timeout error.

To resolve the issue we suggest using the Appearances -> Customize menu to edit the website menus (https://bravacosmeticos.com/wp-admin/customize.php?return=%2Fwp-admin%2Fnav-menus.php) or disabling the “Brands for WooCommerce” plugin (it seems to be responsible for the query) and checking if that resolve the issue.`

I’ve activate and deactivate all plugins, but when Brands for Woo commerce is deactivated all works well. When I need to work at the website, I need to deactivate it in order for me to work.

Thank you!

Hello,

Provided query is taking 1 field from 1 table using 1 text filter. This is transient field for saving cache and this is WordPress core functionality.
I have doubts that this query can causes the timeout error.

Please isntall query monitor https://www.ads-software.com/plugins/query-monitor/ and activate it. When done open slow page. At the top bar there will be QM menu item. Open there queries and copy list here. As I remember there are no sensitive data but you can change path if you want.

Lets check what queries are before this query and where could be issues.

Regards,
Dmytro

The query it’s too long I couldn’t paste it on codepen. Let me find a tool that do that-

https://justpaste.it/9sv9n

• This reply was modified 2 years, 2 months ago by Saxagenia.
• This reply was modified 2 years, 2 months ago by Saxagenia.

And also this: update_option(‘_transient_br_brands_cache_list’)

I am facing the same issue and it’s really frustrating.