WPML is too big

Please make sure to update to WPML 4.3.6 and check our list of Known Issues before reporting

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, Special Testing, String Translation, WPML 4.2.8 ST changes

This topic contains 13 replies, has 2 voices.

Last updated by nuriG 3 months, 1 week ago.

Assigned support staff: George Botsev.

Author	Posts
October 7, 2019 at 5:21 pm #4709629
nuriG	Dear, 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?" Can you please help on this ? Thanks
October 8, 2019 at 9:39 am #4713691
George Botsev Supporter Languages: English (English ) Timezone: Europe/Sofia (GMT+02:00)	Hello and thank you for contacting us. 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.
October 10, 2019 at 1:09 pm #4730777
nuriG	My hosting provider siteground has shut down my site because the tables are too big !!!!!!!!!!!!!!!!!!!!!!!!!!!! How can I split it ??????? Help me now !!!!!
October 10, 2019 at 1:12 pm #4730791
nuriG	And yes I have the latest version of WPML
October 10, 2019 at 1:19 pm #4730813
nuriG	It's urgent please help !!!
October 10, 2019 at 2:55 pm #4731817
George Botsev Supporter Languages: English (English ) Timezone: Europe/Sofia (GMT+02:00)	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.
October 11, 2019 at 7:12 am #4735917
George Botsev Supporter Languages: English (English ) Timezone: Europe/Sofia (GMT+02:00)	Hitting that button won't hurt your translations, but it will hurt your site performance.
October 11, 2019 at 8:00 am #4736207
nuriG	Please open a private section to provide you access and check the issue.
October 11, 2019 at 8:43 am #4736479
George Botsev Supporter Languages: English (English ) Timezone: Europe/Sofia (GMT+02:00)	I have enabled the private reply once more time for your next reply.
October 14, 2019 at 7:11 am #4747469
nuriG	I'll wait for next release for this. Please keep the ticket open until then.
October 14, 2019 at 7:44 am #4747713
George Botsev Supporter Languages: English (English ) Timezone: Europe/Sofia (GMT+02:00)	Okay
October 18, 2019 at 3:08 pm #4783825
nuriG	When is the release coming?
October 21, 2019 at 7:24 am #4791723
George Botsev Supporter Languages: English (English ) Timezone: Europe/Sofia (GMT+02:00)	The release was done today. 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
October 21, 2019 at 10:20 am #4793219
nuriG	My issue is resolved now. Thank you!