Skip Navigation

This thread is resolved. Here is a description of the problem and solution.

Problem:
If you're experiencing very slow backend performance with WPML when updating products, taking up to 20 seconds, we have investigated this issue.

Solution:
First, check your database's

_options

table for any unusually large entries that could be affecting performance. You can use the following SQL query to identify large autoloaded options:

SELECT option_id, option_name, sum(char_length(`option_value`))/1024 as size FROM `wp2x_options` WHERE `autoload` = 'yes' GROUP BY option_id ORDER BY size DESC

Next, we recommend updating to the latest version of WooCommerce Multilingual, which includes a performance upgrade. You can download it from our site here: https://wpml.org/downloads/
For more information about the performance upgrade, please visit: https://wpml.org/compatibility/2023/11/woocommerce-multilingual-5-3-full-support-for-hpos-and-more/
After updating, go to WooCommerce -> Settings and enable HPOS. Then, test your site's performance again.

If you have tested and the issue persists, or if this solution doesn't seem relevant to your situation, please open a new support ticket with us for further assistance: Contact WPML Support

This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.

Tagged: 

This topic contains 30 replies, has 2 voices.

Last updated by Bobby 1 year, 1 month ago.

Assisted by: Bobby.

Author Posts
December 5, 2023 at 1:19 am #14992083

Bobby
Supporter

Languages: English (English )

Timezone: America/Los_Angeles (GMT-08:00)

Thank you for the access details!

Please go to Plugins->Add new->Commercial tab and update WPML to 4.6.8

Let me know once done and i will review again.

December 5, 2023 at 1:45 pm #14998369

mattiasL-9

Ok i have now update WPML to 4.6.8

December 6, 2023 at 12:34 am #15003243

Bobby
Supporter

Languages: English (English )

Timezone: America/Los_Angeles (GMT-08:00)

Dashboard speed is in the 3 seconds zone which is acceptable and would not be considered slow.

When I attempt to edit the item in your screenshot with post id 538482 I get a message that it no longer exists

Running an update on this product as an example I did get a much longer loading speed of around 7-9 secs

hidden link

I am communicating with our second tier and will update you shortly

December 6, 2023 at 8:04 am #15004249

mattiasL-9

Yes dashboard speed is ok. Its just when you update any product you get a loading speed of what you have, around 7-12 seconds.

ok thank you.

December 14, 2023 at 1:55 pm #15064019

mattiasL-9

Any update on this?

December 15, 2023 at 4:27 pm #15074987

Bobby
Supporter

Languages: English (English )

Timezone: America/Los_Angeles (GMT-08:00)

I have followed up with our seecond tier team as well as running tests again and the results are the same as previously.

Load time 4.96sec.
DomContentLoaded time 4.49sec.
Finished (all requests) 15.85 - but this is normal because there are 353 requests.

You can see that pressing the update takes less than 9secs

We cannot confirm this performance issue is caused by WPML, rather The majority of the requests are .css and .js files.

"They come from various plugins and not only from WPML
It all takes a tiny bit of time to load - this is why minification and concatenation is usually recommended."

Screen Shot 2023-12-15 at 8.26.54 AM 1.png
Screen Shot 2023-12-15 at 8.25.25 AM.png
Screen Shot 2023-12-15 at 8.25.14 AM.png