Database caching help needed

[aryaziai]

Hello awesome people,

I've been using Wordpress on Heroku for many months thanks this repo! The only issue I'm having is with my database size. I'm only using a few plugins but have many posts. I have 4,000 posts and 4.0mb db size. I use wp-optimize plugin everyday to remove any transient data. Recently the site jumped to a 6.5mb database size and nothing had been changed, still 4,000 posts, no additional comments or plugin changes. I began deleting posts but the db size wouldn't change and after about 30 seconds I'd be kicked off the site for 1 hour because of the 5mb db size limit with this current heroku plan.

Eventually, I deleted every row from wp_posts but the db size is still 6.5 mb. This leads me to believe that there is still some database caching going on. I'm planning on creating a fresh new site, but unless this database size issue is resolved, I will run into the same problem in a few months.

Thank you in advance.

Ps. I used to use object-cache and it was making my site very fast, instead of 50 queries there would be only be around 5 queries when visiting my homepage. After 1 month, I began getting the classic "There has been a critical error on your website" error. I disabled all of my plugins but nothing changed. Once I deleted object-cache.php from web/app (also commented it out in the composer.json), then the problem went away. I'd love to setup object-cache again, so if anyone has a long-term solution please share.