Management of the database and its indiscriminate increase

  • Resolved alfopap

    (@alfopap)


    7 years, 8 months ago

    I’m trying wordpress and TranslatePress with woocommerce and other plugins. I see that the database increases every time you access the plugin and a new string is detected on the page you want to translate.
    with 2 languages (ita and eng) these 3 tables are created
    wp_trp_dictionary_it_it_en_us
    wp_trp_gettext_en_us
    wp_trp_gettext_it_it

    Is it possible to delete all lines without translation from wp_trp_dictionary_en_en_us_us to eliminate those that are no longer used without any inconvenience?
    Is it possible to delete from the wp_trp_dictionary_en_en_us_us all lines with translation that are not used in the whole site?
    If you delete lines new lines are recreated at the entrance of the translation of every single page?
    Is it possible to change the lines id to reorder them in progressive order?

    With which number of lines does the increase in these tables affect the performance of the site?

    the last question makes sense to all the others to understand if and when to clean the database.

    Thank you

Viewing 1 replies (of 1 total)
  • Plugin Author Cristian Antohe

    (@sareiodata)

    7 years, 8 months ago

    Hello,

    Currently there is no way to clean these tables as by default we’re storing every string we find.

    I’ll ask our developers to see if this is really needed and if we can store just those that have a translation. There might be a technical reason why this is implemented like this.

    > With which number of lines does the increase in these tables affect the performance of the site?
    This only impacts the size of the database. Not the actual speed of your website.
    While this structure might seem un-optimized, it’s actually the fastest way of doing queries and getting the translations back from the database. As a matter of fact, the bottleneck is the php dom parser that finds all the strings for the translation, not the database queries.

Viewing 1 replies (of 1 total)

The topic ‘Management of the database and its indiscriminate increase’ is closed to new replies.