Request for Guidance on Reducing Autoloaded Data Bloat in WCML - WPML

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.

This topic contains 3 replies, has 1 voice.

Last updated by Andreas W. 1 month, 2 weeks ago.

Author	Posts
March 4, 2025 at 2:17 pm #16774595
khalidA-55	Background of the issue: I am trying to optimize the database usage of WooCommerce Multilingual (WCML) on my WordPress site. During a performance audit, I identified significant autoloaded data in the wp_options table related to WCML, specifically the wcml_trbl_translated_variations option, which currently occupies ~0.2 MB of autoloaded data. My site’s wp_options table has grown excessively due to autoloaded data (currently over 1.2 MB). URL: hidden link WPML/WCML Versions: last ones Hosting Environment: Dreampress from dreamhost Symptoms: The wp_options table has grown excessively due to autoloaded data, specifically the wcml_trbl_translated_variations option. Questions: Is there a recommended method to reduce or optimize the size of wcml_trbl_translated_variations without breaking translated product variations? Does WCML provide built-in tools to periodically clean up transient or autoloaded data? Are there known configurations or database optimizations (e.g., adjusting autoload settings) specific to WCML that I can safely implement? Are there alternative storage methods (e.g., moving this data to a non-autoloaded table) supported by your plugin?
March 5, 2025 at 1:10 pm #16778802
khalidA-55	Please respond ASAP my database is bloating i need to clean it, if it's safe for WPML variation thanks
March 6, 2025 at 4:28 pm #16784675
khalidA-55	over 2 days without any response?! is that normal? what happen with the customer support?!
March 8, 2025 at 2:27 pm #16791299
Andreas W. WPML Supporter since 12/2018 Languages: English (English ) Spanish (Español ) German (Deutsch ) Timezone: America/Lima (GMT-05:00)	Hello, Generally, those autoload functions might be necessary to display the product variations on your products in all languages. If you have many products with many variations you might find more entries than usual. Did you already try to delete the transients in WooCommerce > Status > Tools? Guide: https://woocommerce.com/document/understanding-the-woocommerce-system-status-report/tools/ Another way might be to disable the autorun for the option by running the following function, but I can not tell how far this could affect your product translations: update_option('wcml_trbl_translated_variations', get_option('wcml_trbl_translated_variations'), false); Best regards Andreas