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

Orange Pi Development Boards

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 http://www.webpagetest.org.

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 http://www.webpagetest.org 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.

Support CNX Software - Donate via PayPal or become a Patron on Patreon

2
Leave a Reply

avatar
2 Comment threads
0 Thread replies
0 Followers
 
Most reacted comment
Hottest comment thread
2 Comment authors
cnxsoftGroup Of Oceninfo Recent comment authors
  Subscribe  
newest oldest most voted
Notify of
Group Of Oceninfo
Guest

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 : https://wordpress.org/plugins/wp-optimize/