Background of the issue:
We have a multisite install and are running a loop to clean up each subsite's WPML tables. The process involves deleting untranslated strings and optimizing the affected tables using the following queries:
DELETE FROM `wpif_{$site_id}icl_strings` WHERE `status` 10;
DELETE FROM `wpif_{$site_id}icl_string_translations` WHERE `status` 10;
TRUNCATE TABLE wpif_{$site_id}icl_string_pages;
TRUNCATE TABLE wpif_{$site_id}icl_string_urls;
OPTIMIZE TABLE `wpif_{$site_id}icl_strings`;
OPTIMIZE TABLE `wpif_{$site_id}icl_string_translations`.
Symptoms:
Questions:
Please validate that we understood right; this will delete any incomplete translations and to refill the tables (if need be), we can go ahead and scan the theme/plugins.
Are there other tables that should be emptied to further clean the database considering we have a high volume of subsites?
