<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.