Cogito ergo sum

How to reduce the size of wp_icl_strings table in my wordpress database1 min read

Just like a lot of WordPress users, I use for a client WPML to make the website multilingual. The plugin is a magical plugin, and it enables you to translate everything on your website. To make the translation process more easier for the user, WPML just tracks down every single added string to the database, which is not always necessary. This tracking leads to huge database usage and an exponential growth of the size of the WPML-tables.
One example of this problem is the size of the table wp_icl_strings. Because WMPL keeps track of everything, there are a lot of ghost entries, rather untranslated string, stored in the database.

Run the following query to reduce the size of the table:

DELETE FROM `wp_icl_strings` WHERE status = 0;

The query will remove untranslated strings (status = 0) from the database.


About the author

Peshmerge Morad

Data Science student and a software engineer whose interests span multiple fields.

Add comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

By Peshmerge Morad
Cogito ergo sum