Having a clean and fast loading blog is must have one thing to enjoy perfect blogging. Loading time is such a big impact in blogging that this can not only make your readers happy but Google also love fast loading blogs. A blog which give great experience to end-user is the winner in every aspects.
There are too many things to care about when you run a WordPress blog.
Few days back I shared about a plugin to check broken links. The plugin I mentioned in that post is must have plugin for every blog because broken links create too many issue in your blog.
Do you know that everytime when you edit any post 5-6 times before publishing, WordPress makes a revision table for our posts. In simple words when you edit any posts then WordPress keep saving that post in its database.
Let’s take an example
If you have any post which is of 700 words and total size of 10kb. You edited that post 10 times before publishing. Everytime when you will save this post in draft, WordPress will save its copy in its database.
So 10kb x 10 = 100kb.
Now you have around 100kb data in your database which is of no use.
Here I am going to share a great plugin called WP-Optimize which will help you to solve your issue.
Here are the steps to use this plugin.
1. Install and activate the plugin.
2. Now you will see an option called WP-Optimize at left side of your dashboard panel.
3. Open it and see how many revision you have. Below is the screenshot of my blog.
Note: Take proper care while selecting the options because it can delete all your Unapproved comments.
5. Check options Remove all Post revisions and Optimize database tables.
6. Click Process.
Once the processing will be done, go to the end of the page.
You will see like this.
This shows how many data I have saved after optimizing my database.
Benefits of this plugin
- WP-Optimize reports which database tables have overhead and wasted spaces also it allows you to shrink and get rid of those wasted spaces
- This can remove all SPAM comments in just single click.
- You can easily delete posts revisions.
- Remove all draft posts with single click (do only if there is not any important post in draft).
- Apply mysql optimize commands on your database tables without phpMyAdmin.
Install this great plugin on your blog and make it load faster as you are having less load on your database now. Make your blog clean by deleting all revisions and optimizing the database.
20 Most Memorable and Inspirational Quotes from Steve Jobs Life
6 WordPress Captcha Plugins to Reduce Spam in your Blog
Top 5 Reason to use Headlines Theme by Woothemes
About Kulwant Nagi
Kulwant Nagi is a 25 years old Full-Time Blogger from Haryana, India. He Loves to write about SEO, WordPress and Blogging. Blogging Cage is a webmasters blog where you will learn blogging and SEO Tips. 
Hi Kulwant…
Its a great pick….
Hosting companies provide limited space for databases and filling your database with unwanted copies of article can force you to buy additional database space but this plugin really hekps non-techie guys to cleanup database.
Sandeep Kumar recently posted..Blogging for Beginners–6 Weeks Blogging Course-Absolutely Free
This is really a great plugin and helping me everytime to keep my blog clean.
Kulwant Nagi recently posted..WP-Optimize: A Plugin to Make Your WordPress Blog Clean
Great Tip kulwant,I use WP Optimize in all my blogs and I recommend other bloggers to optimize the database once or twice a month.
Vivek R recently posted..All you need to know about : Post Revisions in WordPress
That’s great but I’m worry about DB security. Is this plugin safe to remove data from DB? I mean is it compatible with all major plugins like WP SEO, jetpack etc.?
Dipra Sen recently posted..30 Efficient WordPress Security Plugins & Tips [Infographic]
This plugin is very secure. I am using all the plugins you mentioned here. I never got any issue.
Kulwant Nagi recently posted..BCIS 8: Interview With Vishad Shanghvi From GyaanExchange.com
Hi Kulwant,
Thanks for your reply, I was worried about DB security. After your information I can now try it without any hesitation. I’ll post my experience with this plugin later in this post.
Thanks,
Dipra Sen
Dipra Sen recently posted..How to Create Custom Form in WordPress using PHP
Hey Kulwant,
The biggest help this plugin is giving me is getting rid of spam comments.
thakns
Akos
This plugin will help you in many ways.
Kulwant Nagi recently posted..BCIS 8: Interview With Vishad Shanghvi From GyaanExchange.com
Hey Kulwant Nice article buddy, but somewhat old… I myself use Wp-optimize to make the database cached regularly.
Muhammad Haroon recently posted..Review: Premium WordPress Subscription Plugin with Wpsubscribers
This plugin in not better than wp-cleanfix. That is the best plugin in its class. I think you should update your readers.
rakesh kumar recently posted..7 Advance Comment script for Better SEO
I will try this plugin for sure. If this will work good for me then I will update it.
Thanks for the suggestion.
Kulwant Nagi recently posted..5 Tasks New Bloggers Need To Accomplish Before Writing a Word
Thanks so much for Featuring my plugin
It’s great to see it helped out others. That was the purpose of making it.
Ruhani Rabin recently posted..How Social Media Creates a New Generation of Brand Ambassadors
Good to hear that you made this awesome plugin. I am looking to design a plugin hope you can help me.
Kulwant Nagi recently posted..5 Tasks New Bloggers Need To Accomplish Before Writing a Word
Awesome Plugin, I was searching for this Kind of plugin to Clean My Spam comments automatically and optimize database tables.
Thanks a Lot for sharing and reviewing this Unique WP Plugin!!
Murtaza Ali recently posted..How to Unlock Vodafone K3770z with Original Dashbaord
Glad to see this post regarding WordPress, I would like to make my WordPress website free from errors. This is one of the best techniques to look WordPress cleaner.
Kim Meredith Smith recently posted..7 Tips for Website Redesign
Seriously, i didn’t know about this plugin. Gonna use this on my Blog.
Thanks for sharing bro
Salman Ahmad recently posted..5 Points to be Successful against Google Penguin