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.
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.