Title: Skyrocketed Database size
Last modified: March 9, 2023

---

# Skyrocketed Database size

 *  Resolved [Konstantinos Sakkas](https://wordpress.org/support/users/kosakkas/)
 * (@kosakkas)
 * [3 years, 1 month ago](https://wordpress.org/support/topic/skyrocketed-database-size/)
 * After having installed the free plugin for some time now, I just received notice
   from my host that I am nearing my account’s disk quota. I checked what could 
   be taking up so much space, and I noticed that the database was abnormally large.
   I checked the database with sort by size (desc) and there are two tables named
   trp_dictionary_el_en_us and trp_original_strings which are using as much as 1GB
   of disk space. For a comparison, the postmeta table takes up only 100MB and the
   posts table takes up only 50MB. Can’t those two trp tables be more efficient?
   Is it a misconfiguration on my behalf maybe?
 * In an attempt to troubleshoot this, I tried to deactivate the plugin temporarily,
   and I immediately noticed a speed increase in all aspects of my site, both in
   the front, and in the back end. These two facts can not be unrelated for sure.
   Please advise with regards to speed optimization as well. I wouldn’t want to 
   use a plugin which would patch one hole in my site, and open a larger one.
 * Thank you.

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [Dragos](https://wordpress.org/support/users/dragosvrejiu/)
 * (@dragosvrejiu)
 * [3 years ago](https://wordpress.org/support/topic/skyrocketed-database-size/#post-16554244)
 * Hello, 
   Thank you for getting in touch!This behavior is definitely not normal.
   Would you please check if the trp* tables contain duplicate strings? In case 
   duplicates can be found, please go to Settings -> TranslatePress -> Advanced 
   and use the “Remove duplicate rows” feature. In case duplicates can not be found,
   please look for unusual strings – such as links or lots of entries that do not
   make sense.Best wishes,
 *  Thread Starter [Konstantinos Sakkas](https://wordpress.org/support/users/kosakkas/)
 * (@kosakkas)
 * [3 years ago](https://wordpress.org/support/topic/skyrocketed-database-size/#post-16555924)
 * Hey, thanks for the insight. I have run the remove duplicate rows process, and
   have brought down the sizes of the two tables significantly. trp_dictionary_el_en_us
   now only takes up 178MB while trp_original_strings just 3MB. Additionally there
   has been a significant speed bump to the better without any compromises. Cheers!

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Skyrocketed Database size’ is closed to new replies.

 * ![](https://ps.w.org/translatepress-multilingual/assets/icon.svg?rev=3166541)
 * [Translate Multilingual sites - TranslatePress](https://wordpress.org/plugins/translatepress-multilingual/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/translatepress-multilingual/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/translatepress-multilingual/)
 * [Active Topics](https://wordpress.org/support/plugin/translatepress-multilingual/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/translatepress-multilingual/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/translatepress-multilingual/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [Konstantinos Sakkas](https://wordpress.org/support/users/kosakkas/)
 * Last activity: [3 years ago](https://wordpress.org/support/topic/skyrocketed-database-size/#post-16555924)
 * Status: resolved