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