If we don’t have the post reviews disabled in WordPress the database will be filled with versions of our posts that will never be published.
By default, the posts you are editing are saved as revisions. This makes our post table increases considerably in number of records that in 99% of the cases we will not use in our WordPress. In the long term it can penalize with the performance of the database.
This solution is the most effective and drastic at the same time, since the system would no longer make any of the posts we edit self-saved. We can do it in the following way:
define('WP_POST_REVISIONS', false);
This solution is not bad but we would still leave trash in the database, it would be like that:
define('AUTOSAVE_INTERVAL', 300);
This solution is similar to the previous one, it is still not complete, we would get it this way:
define('WP_POST_REVISIONS', 5);
To remove the autosaved revisions we must apply this SQL code, I recommend first to make a backup…:
DELETE FROM wp_posts WHERE post_type = 'revision';