Title: SQL table getting huge Last modified: May 2, 2024 --- # SQL table getting huge * Resolved [xurxomatic](https://wordpress.org/support/users/xurxomatic/) * (@xurxomatic) * [2 years ago](https://wordpress.org/support/topic/sql-table-getting-huge/) * Hi! * We have detected that one of the Nija Forms tables is very large. We have removed submissions, but still the size does not change. * The table is wp_nf3_object_meta * Is it safe to truncate it? - This topic was modified 2 years ago by [xurxomatic](https://wordpress.org/support/users/xurxomatic/). Viewing 9 replies - 1 through 9 (of 9 total) * [Shaylee](https://wordpress.org/support/users/shayleehansen30/) * (@shayleehansen30) * [2 years ago](https://wordpress.org/support/topic/sql-table-getting-huge/#post-17729564) * Hello [@xurxomatic](https://wordpress.org/support/users/xurxomatic/), * Thank you for reaching out about the large size of your **wp_nf3_object_meta table.** It’s important to handle this carefully, as truncating the table could potentially lead to data loss. * This table typically stores metadata related to the ‘**Save Progres**s’ feature and other form elements, which might not automatically clear even after submissions have been removed. Truncating this table without a clear understanding of its contents could remove essential data unexpectedly. * Before taking any action, I recommend exporting and reviewing the data to determine its nature. If you’re unsure how to proceed or need help analyzing the data, please [feel free to send us a copy](https://ninjaforms.com/contact). We’re here to assist you in ensuring that any action you take is safe and does not affect the functionality of your forms. * Thread Starter [xurxomatic](https://wordpress.org/support/users/xurxomatic/) * (@xurxomatic) * [2 years ago](https://wordpress.org/support/topic/sql-table-getting-huge/#post-17735085) * Hi! * Thank you for your quick response! The form submissions are all empty, but the table size remains the same. I’ve exported all the forms and the combined size of all of them is 81KB. The database table is 933MB in size. * I don’t think your contact form will allow me to attach a file of that size. * [Faisal Ahammad](https://wordpress.org/support/users/faisalahammad/) * (@faisalahammad) * [2 years ago](https://wordpress.org/support/topic/sql-table-getting-huge/#post-17737738) * Hey [@xurxomatic](https://wordpress.org/support/users/xurxomatic/), * Have you tried optimizing your database table to reduce its size? If not, you can try using the following plugins. However, make sure to back up your database before optimizing it. * [https://wordpress.org/plugins/wp-optimize](https://wordpress.org/plugins/wp-optimize) * [https://wordpress.org/plugins/rvg-optimize-database](https://wordpress.org/plugins/rvg-optimize-database) * Give it a try, and let me know how that goes! 😄 * [Shaylee](https://wordpress.org/support/users/shayleehansen30/) * (@shayleehansen30) * [2 years ago](https://wordpress.org/support/topic/sql-table-getting-huge/#post-17741342) * _Thanks for helping _[@faisalahammad](https://wordpress.org/support/users/faisalahammad/)_!_ * _ Please keep in mind you can also reach out to our [Customer Success team](https://ninjaforms.com/contact) who are well-equipped to dive deeper into this issue with you. Plus, by logging this problem, it’ll help us keep track of it and ensure we’re working on a solution that’ll benefit not just you, but all of our users facing similar challenges. * Thread Starter [xurxomatic](https://wordpress.org/support/users/xurxomatic/) * (@xurxomatic) * [2 years ago](https://wordpress.org/support/topic/sql-table-getting-huge/#post-17744338) * Hi [@faisalahammad](https://wordpress.org/support/users/faisalahammad/) * Thank you! Yes, I did, but with no luck… The table size remains the same. * I’m puzzled about this. How is it possible that the database table takes up almost 1GB when there are no submissions registered? I have deleted them all! - This reply was modified 2 years ago by [xurxomatic](https://wordpress.org/support/users/xurxomatic/). * [Faisal Ahammad](https://wordpress.org/support/users/faisalahammad/) * (@faisalahammad) * [2 years ago](https://wordpress.org/support/topic/sql-table-getting-huge/#post-17744365) * Hi [@xurxomatic](https://wordpress.org/support/users/xurxomatic/), * You’re welcome. There might be some dump data in the table, or data that was not deleted after removing the entries. Can you please follow the steps above and let me know how it goes? * Thread Starter [xurxomatic](https://wordpress.org/support/users/xurxomatic/) * (@xurxomatic) * [2 years ago](https://wordpress.org/support/topic/sql-table-getting-huge/#post-17746186) * Hi! * I have installed both plugins and run the optimizations, but the table size has not changed. This is how it looks like: * [https://drive.google.com/file/d/1MSWfwVv6H05ibfJ2kxAMlw9aCv25C_ZY/view?usp=sharing](https://drive.google.com/file/d/1MSWfwVv6H05ibfJ2kxAMlw9aCv25C_ZY/view?usp=sharing) * [Faisal Ahammad](https://wordpress.org/support/users/faisalahammad/) * (@faisalahammad) * [2 years ago](https://wordpress.org/support/topic/sql-table-getting-huge/#post-17750755) * Hi [@xurxomatic](https://wordpress.org/support/users/xurxomatic/), * The issue appears to be more complex than I initially thought. I recommend contacting the **Ninja Forms** support team ([https://ninjaforms.com/contact/](https://ninjaforms.com/contact/)) for assistance in resolving this matter. * Please keep me posted about the outcome. Thank you 👍 * [respectyoda](https://wordpress.org/support/users/respectyoda/) * (@respectyoda) * [2 years ago](https://wordpress.org/support/topic/sql-table-getting-huge/#post-17764340) * Hello [@xurxomatic](https://wordpress.org/support/users/xurxomatic/), WP-Optimize is the go-to plugin for DB optimizing, but you might want to check this Advanced DB Cleanup plugin: [https://wordpress.org/plugins/advanced-database-cleaner/](https://wordpress.org/plugins/advanced-database-cleaner/) Viewing 9 replies - 1 through 9 (of 9 total) The topic ‘SQL table getting huge’ is closed to new replies. * ![](https://ps.w.org/ninja-forms/assets/icon-256x256.png?rev=1649747) * [Ninja Forms - The Contact Form Builder That Grows With You](https://wordpress.org/plugins/ninja-forms/) * [Frequently Asked Questions](https://wordpress.org/plugins/ninja-forms/#faq) * [Support Threads](https://wordpress.org/support/plugin/ninja-forms/) * [Active Topics](https://wordpress.org/support/plugin/ninja-forms/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/ninja-forms/unresolved/) * [Reviews](https://wordpress.org/support/plugin/ninja-forms/reviews/) * 12 replies * 4 participants * Last reply from: [respectyoda](https://wordpress.org/support/users/respectyoda/) * Last activity: [2 years ago](https://wordpress.org/support/topic/sql-table-getting-huge/#post-17764340) * Status: resolved