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?
