Huge wordpress database usage, major performance problem

  • Resolved jubilo

    (@jubilo)


    2 years, 9 months ago

    Hello, we have tested the plugin and we find it is very good and useful.

    We have only one problem, as the information is stored in the database, which generates important problems of perfomance.

    On several sites, the space varies from 600 megabytes minimum to several gigas.
    Apparently there is no limit to the amount of space the plugin can occupy.

    rednao_wc_invoices_created.ibd —- Grow without limits

    Being the plugin that takes up the most space in the database.
    I attach some examples, but in other cases it makes it unusable since it grows to gigantic sizes.

    https://ibb.co/KwLdM8h
    https://ibb.co/d5vqgp6

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author EDGARROJAS

    (@edgarrojas)

    Hello!

    That could be caused because the plugin also saves the html code of the pdf in that table, since that field is no longer used in recent versions of the plugin it will be changed so it doesn’t save the pdf code which should have a huge (beneficial) impact in the size of that table.

    If you have the latest version of the plugin you can also update the html column of that table to null to see the difference.

    Regards!

    Thread Starter jubilo

    (@jubilo)

    Thanks for your answer.
    Does it mean that by updating the plugin to the latest version, I can delete the columns in the database and no data will be lost? I mean, relevant data of the invoices.

    Plugin Author EDGARROJAS

    (@edgarrojas)

    You can’t delete it becuase the insertion still will try to fill that column (this will be corrected in the next release) but that column is no longer used by any process so you can update the records to set the html column of all the records to null, i recommend you though (as i would recommend in any direct database update) to do a back up of the database first.

    Thread Starter jubilo

    (@jubilo)

    Thank you, we are waiting for the update.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Huge wordpress database usage, major performance problem’ is closed to new replies.