Wpml has been very very slow lately in back end

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: Performance

This topic contains 30 replies, has 2 voices.

Last updated by Bobby 1 year, 1 month ago.

Assisted by: Bobby.

Author	Posts
November 9, 2023 at 6:46 am #14762335
mattiasL-9	Hi and thanks for the suggestions. I have tried to follow your suggestions, and it did not improve much on the live site to be honest. But before i give you credentials to the live site, i will need your approval to not deactivate, install or remove any plugins like you have done on the test site. And you cant even update to wordpress 6.4 on the live site, because sites that have that are on the same hosting and have the same checkout like this site have, have seen that when update to wordpress 6.4 the site crashed.
November 9, 2023 at 7:39 pm #14770755
Bobby Supporter Languages: English (English ) Timezone: America/Los_Angeles (GMT-08:00)	If we get access to the live site are we able to do the following: 1. Use cloudways to copy to our staging servers in case further debugging is needed that way we do not make changes on the live site. You would need to install the plugin "Cloudways migration" 2. Update a product to note its loading time (no changes will be made) Private reply enabled.
November 10, 2023 at 6:38 am
November 14, 2023 at 7:33 am
November 14, 2023 at 7:49 am #14794199
mattiasL-9	Hello. Ok so can you guide me on how to check the "Autoloaded" data from wp_options table? Have never done that before.
November 14, 2023 at 3:28 pm #14799911
Bobby Supporter Languages: English (English ) Timezone: America/Los_Angeles (GMT-08:00)	Absolutely. You login to your database -> locate your _options table (for your it's wp2x_options) and run the following SQL script 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 I was able to do this using the cloudways clone and the following is the results, nothing seems out of the ordinary that could cause potential issues with performance. 4786078 batch_project_HCR8XVlbEldRggXsxbj1FaxHQafbPgWP 246.1826 282293 rank_math_seo_analysis_results 67.9092 557168 cky_banner_template 62.1357 419617 theme_mods_kadence-child 60.0381 17959 kadence_conditional_header_4068 50.6924 1048 theme_mods_kadence 46.3877 102 widget_block 43.4570 4785719 _transient_cky_transient_0.80322800 1699915870_all 32.2764 5010 product_cat_children_all 31.4990 5871 opmc_dropshipping_options 26.8936 3828 icl_sitepress_settings 26.8506 689122 rewrite_rules 23.5537 3942 product_cat_children_sv 16.5859 4786079 channel_attributes 15.4805 5008 product_cat_children_en 14.9326 104 cron 12.0283 18994 rank-math-options-titles 11.9541 4786083 wcml_currency_switcher_template_objects 11.6992 100 wp2x_user_roles 10.8936 Today, we released a new version of WooCommerce Multilingual which you can download from our site here https://wpml.org/downloads/ This version includes a performance upgrade, please review more information about it here: https://wpml.org/compatibility/2023/11/woocommerce-multilingual-5-3-full-support-for-hpos-and-more/ Update the WCML version and then go to WooCommerce ->Settings and enable HPOS then test and let me know your results, please. (if possible test both with WPML enabled and disabled and let me know the loading time using the Page Load Time Google extension -- If I have your permission to do this on the live site I can perform the test it as well)
November 17, 2023 at 7:06 am #14831941
mattiasL-9	Hi again. Well i want to switch to HPOS on the dev site first, so if there is any problems, then its not affecting the live site and we can trouble shoot it on the dev site first before testing on live site. But we have two plugins that is incompatible with HPOS. But HPOS is only for orders, or will it effect product updates as well?
November 17, 2023 at 8:29 pm #14866141
Bobby Supporter Languages: English (English ) Timezone: America/Los_Angeles (GMT-08:00)	Yes, it is, but the 5.3 version also has overall performance upgrades included as well, therefore please do give both a test and let me know your results. At the moment it's important to note that our team did review everything and could not find anything specific on your environment that would be causing a performance issue at least from WPML's side.
November 21, 2023 at 7:06 am #14882071
mattiasL-9	I tried to activate HPOS but it says that WCML 5.2.1 and below requires compatibility mode to work with the new way WooCommerce stores orders (see the attached screen shot). And i appreciate that your dev team have looked if wpml is causing the long loading time when updating products. But are you sure they did not find anything? Because i can see this in my performance report from my web hosting (see the attached screen shot) Best regards /Mattias
November 22, 2023 at 6:25 pm #14901857
Bobby Supporter Languages: English (English ) Timezone: America/Los_Angeles (GMT-08:00)	Hi Mattias, If possible, please go to Plugins ->Add new->Commercial tab-> check for updates and update WCML to 5.3. That version also comes with performance enhancements overall. Let me know your results, please.
November 28, 2023 at 5:42 am #14935853
mattiasL-9	Its already updated to 5.3. Can you please take a closer look at this string in the screen shot to see why it is has such a long (7 seconds) loading time when updating products?
November 29, 2023 at 2:43 am #14945747
Bobby Supporter Languages: English (English ) Timezone: America/Los_Angeles (GMT-08:00)	When I check the site WCML is currently using an older version and not 5.3 also, please update WPML to it's latest released version along with WP ROCKET to 3.15.5, which is a new version they released to fix a known performance issue their plugin was having with WPML. Afterward, let me know your results, please.
November 30, 2023 at 7:39 am #14958773
mattiasL-9	Im doing my tests on the dev site and not on the live site. And i have updated WPML in dev site to 5.3, but i still get the warning that WCML is in 5.2.1 or below?
December 1, 2023 at 10:23 pm #14976347
Bobby Supporter Languages: English (English ) Timezone: America/Los_Angeles (GMT-08:00)	Thank you for updating me! Please share access to the dev site with me if possible.
December 3, 2023 at 6:46 am