Blog Optimization Series :
Revisions to Optimize WordPress Database
When it comes to blogging, most that are serious know about that WordPress is the standard platform of choice. But beyond that they do not know much else about the platform. Including how to optimize WordPress database for their site for increased performance for the user. There are many things that go on in the backend of WordPress that can make the difference if a reader will visit your site again or even stay and read a few posts. The major contributing factor to this is speed. Does your site load quickly for the reader? If it is sluggish then chances are that they will go somewhere else for the content they were searching for. In todays part of the Blog Optimization series I am going to show you how to keep your database from being cluttered when you create and revise blog posts by limiting how many saved versions of the draft and final post are stored on your database.
The easiest method, I have found, to keep this under control is to use a plugin called Revision Control. This is an extremely easy to use plugin and it gives you the option in each post that you create to change the number from your default to more or less depending on what you are working on. I like to keep 3 revisions of a post at any given time. But you can choose to do more or less. If you have multiple users on your site, it will also show the author name of the revisions so that you know if the author, editor, or even admin were the last to alter the blog post. That can be extremely useful in a team setting. If you are just working by yourself the date and timestamps will really help you to keep track of when the last change was made.
By limiting the amount of data that your site needs to retrieve from your host will greatly increase the user experience of your site, as well as keep your bandwidth usage slightly lower, this is great if you are on a shared server and do not want to be penalized by your host for using too many resources and leaving other sites to suffer the lag. While, this is not the only way to improve load times for your site and it can make a difference depending on your host and the server you are using it will play a positive part.
What methods do you currently use to optimize WordPress database for your blog? Is limiting revisions something that you will add to the basic maintenance to optimize WordPress database for your site?