Delete Old Revisions to Reduce Time to First Byte for WordPress Blogs

I’ve already implemented several steps to improve this blog performance:

Those two work pretty well, but there was still a problem with the Time to First Byte according to

F mark for First Byte TimeIt got an F mark for First Byte Time. Sometimes I would get TTFB (Time To First Byte) of 20 seconds and more. TTFB is synonym of slow back-end processing either because of poorly optimized software or insufficient hardware specs or both. Part of the problem is probably due to my hosting provider (I use a shared hosting) and I sometimes get very high server load in CPanel (e.g. 50 (4 cpus)) whether my blog is running or not.

But I found a blog post explaining how to try to reduce the TTFB for WordPress blog by installing Better Delete Revision plugin in order to reduce the size of the WordPress database. So I’ve decided to give it a try.

Here’s what my database looked like before:

 Wordpress Blog Database StructureThe large table was wp_posts with 8.7MB and 2544 rows.

So I backup the WordPress database first and went to the Dashboard in Settings->Better Delete Revision and clicked on Check Revision Posts. It showed me 1842 redundant posts (old revision of my current blog posts). It clicked on Yes, I would like to Delete them! and run a database optimization.

Here’s what my WordPress database looked like after that:

Optimized WordPress Databasewp_posts is now 1.6 MB (vs 8.6MB) and has 702 rows.

Then I went back to to test again. I still get the F mark, but the results still seems somewhat better. It’s quite difficult to judge since I’m on a shared host, there are too many variables I can not control and the results provided by WebPageTest are not consistant since it depends on the server load.

Nevertheless, I don’t think deleting old revisions can be a bad thing, especially if you have been running your blog for a long time and post regularly.

Share this:

Support CNX Software! Donate via cryptocurrencies, become a Patron on Patreon, or purchase goods on Amazon or Aliexpress

ROCK 5 ITX RK3588 mini-ITX motherboard
Notify of
The comment form collects your name, email and content to allow us keep track of the comments placed on the website. Please read and accept our website Terms and Privacy Policy to post a comment.
Group Of Oceninfo
8 years ago

I would also like to mention this plugin can help you to optimize database as revision as well so according to me it’s better :

Khadas VIM4 SBC