[Closed] Our Hosting Company spotted slow database query - I need your assistance

Hello!

Welcome to WPML Support.

I'll do my best to help you solve this issue.

1) Since you are using WPML and Woocommerce and they require a lot of memory, please update memory limit values:

Please open and add the following code in your wp-config.php file, right after the database information lines of code. This file is located in your website's root folder.

 /** Memory Limit */
define('WP_MEMORY_LIMIT', '256M');
define( 'WP_MAX_MEMORY_LIMIT', '512M' );

2) In order to check what goes wrong, we need more info about the query and when it happens.

Can you please install the Query Monitor plugin (https://wordpress.org/plugins/query-monitor/) and check if this slow query happens on specific pages, frontend or backend.

3) Please check if the issue still happens when only the WPML plugins and WooCommerce active while using the WP default theme.

Please let me know how it goes and don't hesitate to ask if you find any problem along the way or have doubts or questions about the steps mentioned above, I'll do my best to help you in the best way possible.

Regards,
Drazen

Hello Frank,

thanks for getting back.

Actually, we would need to check if the issue happens in a specific case/page or it is caused by other plugins/themes.

So I suggest since you can not do a test on a live website, to create a staging site and there do the suggested test and check if the issue still happens and if it happens in the specific case.

We need to be able to check and reproduce the issue in order to check what goes wrong and how to fix it.

When you install Query monitor, some new information shows up in the admin bar, hovering over you can see more information about your site. Also there you can see if slow queries are happening and which are they. Image attached

You mention in your first reply there is a slow query by WPML, so this is the best way to check when and how it happens and also which query is it exactly.

The best would be to test on a staging site.

Please let me know how it goes and if you need help.

Thanks and kind regards,
Drazen