This thread is resolved. Here is a description of the problem and solution.
Problem:
The size of icl_string_pages is growing huge. How can I stop this from happening?
Solution:
If the table is growing, one of the possible causes for that behaviour would be creating duplicate strings on new pages. If there are dynamically generated strings that would be causing this increase, you would see a parallel increase also in the table _icl_strings. Please check if this is the case.
You can check sorting the table by IDs and check if there is a specific page generating all this strings. You could check the latest strings to see if they are different or the same and exclude the text-domains to which they belong from auto-registering in WPML > String Translations.
Another possible cause for this is aggressive caching for logged users, that could be registering strings more than once. If you have identified a specific page generating many of these strings, please check the caching for this page and disable it for logged-in users.
Also, try reducing the size of the tables. You can run this MySql query instead of deactivating and reactivating the plugins:
TRUNCATE TABLE wp_icl_string_pages; TRUNCATE TABLE wp_icl_string_urls;
Then, go to WPML > String Translation > Auto register string for translation > Edit and exclude all the text domains.
Relevant Documentation:
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.
Our next available supporter will start replying to tickets in about 2.12 hours from now. Thank you for your understanding.
This topic contains 2 replies, has 2 voices.
Last updated by Ariel 2 years, 5 months ago.
Assigned support staff: Lauren.
 Ariel |
 Lauren Supporter Languages: English (English ) Timezone: America/New_York (GMT-04:00) |
|
Ariel |
