# Optimising the WordPress database

> Remove old post revisions and other clutter from your WordPress database with the Optimize Database after Deleting Revisions plugin.

Source: https://helpcenter.ruachost.com/wordpress/guides/optimizing-wordpress-database/

Over time, your WordPress database accumulates unnecessary data such as post revisions, trashed posts, spam comments, and transient options. This can slow down your site. On **ruachost.com**, you can optimize your database using the **Optimize Database after Deleting Revisions plugin**.

## Why Optimize the Database?

- Reduces database size and improves performance.
- Removes clutter like old revisions and unused data.
- Speeds up queries and page load times.
- Helps maintain a healthy WordPress installation.

## Steps to Install and Configure the Plugin

1. **Log in to WordPress** with an administrator account.
2. In the dashboard, go to **Plugins → Add New**.
3. Search for **Optimize Database after Deleting Revisions**.
4. Click **Install Now**, then **Activate**.
5. In the dashboard, go to **Settings → Optimize Database**.
6. Configure options:

   - Choose how many revisions to keep per post/page.
   - Exclude specific posts or pages from revision deletion.
   - Select which database tables to optimize.
7. Click **Save Settings**.
8. Run optimization manually or schedule automatic optimization.

✅ The plugin will clean up unnecessary data and reduce database size.

## Important Notes

- Always back up your database before running optimization.
- Avoid running optimization during peak traffic times.
- Exclude tables that store critical plugin data if needed.
- Regular optimization helps keep your site fast and efficient.
