I'm using the plugin WP Staging for creating staging copies of my site. However, the creation takes half hour whereas it takes only 5 minutes without WPML.
The plugin support team says that "the problem is within this table: "wp_icl_string_pages", its size is "568.89 MB" and it takes most of the time during the staging site creation process. I believe it's related to WPML plugin, so I suggest asking them why this table is so large like this and if there is any option to optimize it?"
The table icl_string_pages is related to WPML String Translation plugin.
That plugin is part of the WPML CMS license type and as far as I can notice you have WPML Multilingual Blog license type.
So I suggest that you should update your WPML license type and update WPML String Translation plugin.
In the new versions of WPML and its addons we have optimized the usage of that table and if you update your license you should be able to benefit from the latest performance improvements in the latest versions of our plugins, and even test our beta where this table can be optimized further and not take that much space.
My hosting provider siteground has shut down my site because the tables are too big !!!!!!!!!!!!!!!!!!!!!!!!!!!! How can I split it ??????? Help me now !!!!!
If you wish, you can provide temporary credentials so that I can check the issue, but as far as I know, this issue is addressed in the latest beta of WPML and will be fixed in the next stable release.
Of course, in order to update all of your components, as I said above, you need to have WPML CMS license.
Your current license is for WPML Blog type, which does not include WPML String Translation
