<https://wpml.org/forums/topic/_icl_string_pages-table-with-1-249-429-records/>
Export the database as a backup. Then run the following two sql statements (separately from each other).
TRUNCATE TABLE hws_icl_string_pages;
DELETE FROM `hws_icl_strings` WHERE status = 0;
Code language: JavaScript (javascript)
The following doesn't exist anymore after update to v4.3.3
The icl_string_pages database table gets really large due to string
translation cache. To clear the cache:
- Visit WPML » Support » Troubleshooting page » click on *Recreate ST
DB cache tables* button. This will clear the String Translation
caches, including the wp_icl_string_pages table.
- Visit WPML » String Translation » enable *Auto-Registering* option
for the all the String Domains.