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

    (@dragosvrejiu)

    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

    (@kosakkas)

    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.