Title: Huge wordpress database usage, major performance problem
Last modified: June 7, 2022

---

# Huge wordpress database usage, major performance problem

 *  Resolved [jubilo](https://wordpress.org/support/users/jubilo/)
 * (@jubilo)
 * [3 years, 11 months ago](https://wordpress.org/support/topic/huge-wordpress-database-usage-major-performance-problem/)
 * 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/KwLdM8h)
    [https://ibb.co/d5vqgp6](https://ibb.co/d5vqgp6)

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

 *  Plugin Author [EDGARROJAS](https://wordpress.org/support/users/edgarrojas/)
 * (@edgarrojas)
 * [3 years, 11 months ago](https://wordpress.org/support/topic/huge-wordpress-database-usage-major-performance-problem/#post-15717762)
 * 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](https://wordpress.org/support/users/jubilo/)
 * (@jubilo)
 * [3 years, 11 months ago](https://wordpress.org/support/topic/huge-wordpress-database-usage-major-performance-problem/#post-15718151)
 * 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](https://wordpress.org/support/users/edgarrojas/)
 * (@edgarrojas)
 * [3 years, 11 months ago](https://wordpress.org/support/topic/huge-wordpress-database-usage-major-performance-problem/#post-15719670)
 * 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](https://wordpress.org/support/users/jubilo/)
 * (@jubilo)
 * [3 years, 11 months ago](https://wordpress.org/support/topic/huge-wordpress-database-usage-major-performance-problem/#post-15740762)
 * 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.

 * ![](https://ps.w.org/woo-pdf-invoice-builder/assets/icon-256x256.gif?rev=3517675)
 * [PDF Builder for WooCommerce. Create invoices,packing slips and more](https://wordpress.org/plugins/woo-pdf-invoice-builder/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woo-pdf-invoice-builder/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woo-pdf-invoice-builder/)
 * [Active Topics](https://wordpress.org/support/plugin/woo-pdf-invoice-builder/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woo-pdf-invoice-builder/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woo-pdf-invoice-builder/reviews/)

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [Issues](https://wordpress.org/support/topic-tag/issues/)

 * 4 replies
 * 2 participants
 * Last reply from: [jubilo](https://wordpress.org/support/users/jubilo/)
 * Last activity: [3 years, 11 months ago](https://wordpress.org/support/topic/huge-wordpress-database-usage-major-performance-problem/#post-15740762)
 * Status: resolved