One of the drawbacks to using WordPress is the fact that if you work hard on your website, not only by adding content regularly, but perhaps changing your page copy, trying different calls to action, working on conversions, etc. then your database can ultimately grow quite large.
While a problem may not present itself for months or years, it’s reasonable to assume that someday, something will go wrong and you’ll wish your database was smaller and cleaner. Perhaps it will come during a routine upgrade and you’ll notice something’s out of whack, or the automatic upgrade will fail, forcing you to upgrade manually.
On the other hand, you might discover a problem only after something has gone seriously wrong – like while trying to restore a backup after a loss – and at that point, to put it technically, you are screwed.
Because we manage a lot of domains on a lot of different hosts, we’re probably a lot more prone to see a problem than you are, however, it never hurts to be safe, and be proactive. That’s why it’s a good idea to keep your database clean of unnecessary data.
A few weeks ago, while dealing with a site that had literally hundreds of revisions for every page, and a giant database that was giving us problems moving from one server to another, I looked for a plug-in that would get rid of all these revisions that we no longer needed.
I found a good one in WP Optimize, that not only gets rid of unwanted revisions, but also optimizes the database tables, which was previously only accessible through your web hosts phpMyAdmin.
Rather than tell you all about it, take a look at this 2 minute video…