#2 Test with No WPML + Add-on Plugins + Standard WP Theme Twent23 (products page):
----------------------------------------------------------------------------
Same as above -- this makes no positive change -- sometimes it even brings up the load time to 13.00
#4 From Step #3 we have a range of load time at 3.50 - 4.00 that has been steady, will leave the environment as is, and simply activate WPML
----------------------------------------------------------------------------
Load times are 6.00 - 7.00
As I can reproduce this behavior now with a minimal environment I have escalated this to our second tier. Once there is news you will be updated here. Please leave the staging site up as we will be using it.
On my main site I already have the Query monitor deactivated.
Also, if I deactivate the SSL plugin, won't that remove my SSL certificate???
And how can you expect me to deactivate the caching plugin?? That is essential for my site performance.
"I see you are using Astra, is there any custom work done within the theme by you or another developer in your team."
No.
As for the site speed tests you did. They may not be accurate at this moment. On my main site I am currently busy setting my translated products to drafts (after deactivating WPML). The activities I have been doing might interfere with your tests. But like I said before, on my main site, as soon as I deactivate WPML and the associated plugins, the slowness issue instantly gets resolved. And when WPML IS active, the slowest things in the backend is the orders page, when I need to navigate to an order. With WPML active, I get an average loading time of between 12 and 18 seconds. With WPML off it is about 3 seconds.
"As I can reproduce this behavior now with a minimal environment I have escalated this to our second tier. Once there is news you will be updated here. Please leave the staging site up as we will be using it."
In the past 20 hours I was busy a lot setting my products to drafts in my main site. This could have interferred with the testing you did on the testing site (I'm no expert on this but I wouldn't be surprised if it did).
Like I said, on my main site now that I have WPML and all accessory plugins turned off everything in both the backend and on the front end is much quicker. If you want to see for yourself, let me know and I'll provide login credentials.
I went to the page for this setting in Woocommerce, but the following notification was present: "⚠ This feature should not be enabled: Essential Addons for Elementor, GTM4WP, and WooCommerce Google Ads Dynamic Remarketing plugins are active and not compatible with this."
As this is a fairly newer feature It is expected that not all plugins are compatible. Please make a backup first and then enable it and test if this helps the performance issues. During our tests, it made a substantial difference. Also, WCML is currently fully compatible with it.
What we found is that the call in \WC_Order_Query::get_orders called by \Automattic\WooCommerce\Internal\Admin\WcPayWelcomePage::has_wcpay method in \wp-content\plugins\woocommerce\src\Internal\Admin\WcPayWelcomePage.php
(Coming from Woocommerce's plugin)
generate's a query like the following:
SELECT wp_posts.ID
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )
WHERE 1=1 AND (
( wp_postmeta.meta_key = '_payment_method' AND wp_postmeta.meta_value = 'woocommerce_payments' )
) AND wp_posts.post_type IN ('shop_order', 'shop_order_refund') AND ((wp_posts.post_status = 'wc-pending' OR wp_posts.post_status = 'wc-processing' OR wp_posts.post_status = 'wc-on-hold' OR wp_posts.post_status = 'wc-completed' OR wp_posts.post_status = 'wc-cancelled' OR wp_posts.post_status = 'wc-refunded' OR wp_posts.post_status = 'wc-failed' OR wp_posts.post_status = 'wc-checkout-draft'))
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
LIMIT 0, 1
The query is performing slow, and seems to be slow because it asks for the postmeta table meta key value.
adding an index to the postmeta table will help if you cannot enable High-Performance Order Storage
ALTER TABLE `wp_postmeta`
ADD INDEX `meta_value` (`meta_value`(191));
Run the above query and let me know your results, please.
Note: Our team has concluded that this is not a problem in WooCommerce Multilingual, WPML or WPML String Translation, or any of our products as far as we can gather.
"generate's a query like the following:"
-How do I do that?
"adding an index to the postmeta table will help if you cannot enable High-Performance Order Storage"
-Also, how do I do that?
"Run the above query and let me know your results, please."
-How do I run it?
"Note: Our team has concluded that this is not a problem in WooCommerce Multilingual, WPML or WPML String Translation, or any of our products as far as we can gather."
-So can I delete the testing site then?
