WordPress stores everything in a database — your content, settings, user data, comments, and a significant amount of historical data that accumulates quietly over time. The older a site gets and the more activity it has seen, the more likely it is that the database is carrying unnecessary weight that slows things down.
What builds up in a WordPress database
- Post revisions — WordPress saves a new revision every time you update a post. On a mature site, a single page might have dozens of revisions stored that serve no current purpose
- Trashed and auto-draft content — Deleted posts and auto-saved drafts remain in the database until explicitly cleared
- Transients — Temporary data cached by plugins that is often never cleaned up, even after the plugin is removed
- Orphaned plugin data — When plugins are deleted without proper cleanup, their database tables and options entries often remain
- Spam and unapproved comments — Large volumes of stored spam add database overhead
When database optimisation matters most
On a newer site with limited content, database bloat is rarely a problem. On a site that has been running for several years with active content publishing and multiple plugins installed and removed over time, the database can become a genuine performance bottleneck — particularly for queries that search across large tables.
How often should you clean up?
For most business sites, a quarterly database cleanup as part of routine maintenance is sufficient. It is not something that needs daily attention, but it should be on the maintenance schedule.
Database cleanup is part of our WordPress maintenance service. Read more about performance setup or explore the performance knowledge base.