A small database will work faster than a large database – so it follows that cleaning up your WordPress database from time to time will keep your WordPress website running faster.
Each time you edit a page or a post you are adding to your database with page revisions, over time these revisions can mount up along with a lot of other items that will not be used. We use a plugin that clears out old post revisions, deleted items, unused tags and expired transients. This plugin will also optimise your tables.
Optimize Database after Deleting Revisions plugin will handle the clean up of your database for you.
Maximum number of – most recent – revisions to keep per post / page: 3
Delete trashed items: YES
Delete spammed items: YES
Delete unused tags: YES
Delete expired transients: YES
Delete pingbacks and trackbacks: YES