Title: Database size has increased after optimization ! Last modified: August 14, 2019 --- # Database size has increased after optimization ! * Resolved [rom174](https://wordpress.org/support/users/rom174/) * (@rom174) * [6 years, 10 months ago](https://wordpress.org/support/topic/database-size-has-increased-after-optimization/) * Hello team, * I just run an optimization after backing up my database. I checked optimizing tables, removing revisions and drafts (+4000), removing spams, removing expired transients and metadatas. Then I re backed up the database and it increased by 37mo (from 123mo to 160mo) ! When I compare both files in text editor, I can see that there is a lot of new lines. * Finally, I reloaded a page with and without the cache enabled but I didn’t see any change in the loading time compared to the loading time before the optimizations. So, I wonder if, even with decreased size of the database, I would have seen better performances. * So, now I am a bit confused about the purpose of the optimizations offered by wp-optimize. Can you let me know what I missed and what I did wrong/misunderstood? * Thank you Viewing 4 replies - 1 through 4 (of 4 total) * [Marc Lacroix](https://wordpress.org/support/users/marcusig/) * (@marcusig) * [6 years, 10 months ago](https://wordpress.org/support/topic/database-size-has-increased-after-optimization/#post-11831304) * Hello, * When you say * > When I compare both files in text editor, I can see that there is a lot of > new lines. * , what are those new lines? * The WP-Optimize Database optimisation will add a few records to the options table to record what it did and when, but it will not add anything to your other WP tables. * Regarding the cache, a page needs to be visited once after enabling cache. This first visit will save that page in the cache. So if you enabled cache and refreshed that page once, you wouldn’t get a cached version of it. * If you still have caching enabled, you could share a link here and I’ll confirm what the difference is. * Thread Starter [rom174](https://wordpress.org/support/users/rom174/) * (@rom174) * [6 years, 10 months ago](https://wordpress.org/support/topic/database-size-has-increased-after-optimization/#post-11831396) * Hello [@marcusig](https://wordpress.org/support/users/marcusig/) * Thank you for this quick reply. * > When you say > > When I compare both files in text editor, I can see that there is a lot of > > new lines. > , what are those new lines? * It is content posts for the huge majority. I guess that even a few addition from wp-optimize won’t give an increase of 37mo. * > Regarding the cache, a page needs to be visited once after enabling cache. > This first visit will save that page in the cache. So if you enabled cache > and refreshed that page once, you wouldn’t get a cached version of it. * Yes of course, not sure if we are talking about the same cache. I am talking of the browser cache enabling and disabling it from the button of the inspector. * Thread Starter [rom174](https://wordpress.org/support/users/rom174/) * (@rom174) * [6 years, 10 months ago](https://wordpress.org/support/topic/database-size-has-increased-after-optimization/#post-11837815) * Hello [@marcusig](https://wordpress.org/support/users/marcusig/) Sorry, but I would need to know why this happened and if I have to worry about that weird growth. Do you now where those 37mo are coming ? It seems that [@wb1968](https://wordpress.org/support/users/wb1968/) reported [the same issue with an older version of wp-optimize](https://wordpress.org/support/topic/wp-optimize-2-2-7-doesnt-clean/#post-11083698)? But there is no explaination about the issue in the thread. * Why all those lines have been added in my database? What was the error ? Is there a compatibility issue ? Do I need to restore the database ? * Thank you * [Marc Lacroix](https://wordpress.org/support/users/marcusig/) * (@marcusig) * [6 years, 10 months ago](https://wordpress.org/support/topic/database-size-has-increased-after-optimization/#post-11838147) * Hello, As I said earlier, WP-Optimize does not add anything to the database, and if it does that would be a bug. * You could have an increase in size on the database when running the optimisations because the `OPTIMIZE TABLE` command doesn’t necessarily reduce the size, but optimises for performance. BUT, this shouldn’t make a difference to a backup size. * I can’t tell why those lines were added, because I don’t know what those lines are. * Do you have samples of the extra lines you could show us? * If you are able to restore your database without loosing data, you could look at the row numbers in the tables in both versions of the database, to see if they are different. * If this is not conclusive, would you be able to send a request on this form: [https://getwpo.com/ask-pre-sales-question/](https://getwpo.com/ask-pre-sales-question/), including links to the before and after backup files of your database (not here, as this is a public place). If you add the URL of this topic, and mention me, it’ll find its way to me. Don’t worry about the “Yes, I am asking a pre-sales question” checkbox (it has to be ticked to submit the form, but if you mention this URL, it won’t get deleted!). * That way I would be able to look closer and see where the issue comes from. - This reply was modified 6 years, 10 months ago by [Marc Lacroix](https://wordpress.org/support/users/marcusig/). Viewing 4 replies - 1 through 4 (of 4 total) The topic ‘Database size has increased after optimization !’ is closed to new replies. * ![](https://ps.w.org/wp-optimize/assets/icon-256x256.png?rev=1552899) * [WP-Optimize – Cache, Compress images, Minify & Clean database to boost page speed & performance](https://wordpress.org/plugins/wp-optimize/) * [Frequently Asked Questions](https://wordpress.org/plugins/wp-optimize/#faq) * [Support Threads](https://wordpress.org/support/plugin/wp-optimize/) * [Active Topics](https://wordpress.org/support/plugin/wp-optimize/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/wp-optimize/unresolved/) * [Reviews](https://wordpress.org/support/plugin/wp-optimize/reviews/) * 4 replies * 2 participants * Last reply from: [Marc Lacroix](https://wordpress.org/support/users/marcusig/) * Last activity: [6 years, 10 months ago](https://wordpress.org/support/topic/database-size-has-increased-after-optimization/#post-11838147) * Status: resolved