{"id":811809,"date":"2022-01-08T12:00:00","date_gmt":"2022-01-08T12:00:00","guid":{"rendered":"https:\/\/www.lafactory.com\/blog\/non-classifiee\/how-to-manage-wordpress-revisions-to-optimize-site-performance\/"},"modified":"2022-01-08T12:00:00","modified_gmt":"2022-01-08T12:00:00","slug":"how-to-manage-wordpress-revisions-to-optimize-site-performance","status":"publish","type":"post","link":"https:\/\/www.lafactory.com\/blog\/en\/how-to-manage-wordpress-revisions-to-optimize-site-performance\/","title":{"rendered":"How to Manage WordPress Revisions to Optimize Site Performance"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"post-165384\">\n<p>When you save a draft or update a post, WordPress stores a copy of the changes from the previous version. This feature is helpful if you ever need to revert to a previous version of your content, but these revisions take space in your database. If you have a lot of revisions, this can take up your server storage and possibly impact your site performance over time. In this article, we\u2019ll see how to manage WordPress revisions to optimize your site performance.<\/p>\n<p><iframe loading=\"lazy\" title=\"How to Manage WordPress Revisions to Optimize Site Performance\" width=\"1080\" height=\"608\" src=\"https:\/\/www.youtube.com\/embed\/xYHL61R5OZo?feature=oembed\"  allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe><\/p>\n<p><a class=\"button primary-button inline-button accent-red\" href=\"https:\/\/www.youtube.com\/c\/elegantthemes?sub_confirmation=1\">Subscribe To Our Youtube Channel<\/a><\/p>\n<h2>What We Mean by \u201cWordPress Revisions\u201d<\/h2>\n<p>A revision is just a saved copy of the changes to your page and post content. WordPress automatically stores a revision every 60 seconds while your browser has a post or page open. It also stores a revision every time you click to update.<\/p>\n<p>You can view those revisions to see all the changes made between updates, and you can also restore them to a previous revision. This helps ensure you don\u2019t lose too much of your work if something goes wrong, such as a computer crash or power outage. It also gives you a save point that you can restore if you change your mind on an edit. You can even revisit a different version of your content months later. They\u2019re all stored in the WordPress database for you to see.<\/p>\n<h3>How to Restore Page and Post Revisions<\/h3>\n<p>These stored WordPress revisions make it easy to restore your pages and posts to previous versions. Let\u2019s take a look at how to restore revisions in both the classic and Gutenberg editors.<\/p>\n<h3>How to Restore Post Revisions in the Classic Editor<\/h3>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"with-border aligncenter size-full wp-image-165742\" src=\"https:\/\/www.elegantthemes.com\/blog\/wp-content\/uploads\/2022\/01\/Restore-Post-Revisions-in-the-Classic-Editor.png\" alt=\"Restore Post Revisions in the Classic Editor\" width=\"960\" height=\"486\" \/><\/p>\n<p>In the Classic editor, the list of revisions appears at the bottom under the content editor. Simply click on a revision to see a comparison between that revision and the current content or another revision.<\/p>\n<h3>How to Restore Post Revisions in the Gutenberg Editor<\/h3>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"with-border aligncenter size-full wp-image-165743\" src=\"https:\/\/www.elegantthemes.com\/blog\/wp-content\/uploads\/2022\/01\/Restore-Post-Revisions-in-the-Gutenberg-Editor.png\" alt=\"Restore Post Revisions in the Gutenberg Editor\" width=\"960\" height=\"493\" \/><\/p>\n<p>In the Gutenberg editor, the number of revisions is shown in a separate section in the right sidebar. Click this to open the revision screen.<\/p>\n<h3>Restoring a Post Revision<\/h3>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"with-border aligncenter size-full wp-image-165740\" src=\"https:\/\/www.elegantthemes.com\/blog\/wp-content\/uploads\/2022\/01\/Restore-Post-Revisions-in-the-Classic-Editor-2.png\" alt=\"Restore Post Revisions in the Gutenberg Editor\" width=\"960\" height=\"255\" \/><\/p>\n<p>Clicking a revision in either editor takes you to the same revision screen. It shows you the content for the current date and time on one side of the screen, and what\u2019s different from the current content on the other side. The current revision displays above the content on the left. A <strong>slider<\/strong> and <strong>previous<\/strong> and <strong>next<\/strong> buttons at the top show the various revisions to compare them. As you can see in this example, the revision screen shows the title has changed.<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"with-border aligncenter size-full wp-image-165741\" src=\"https:\/\/www.elegantthemes.com\/blog\/wp-content\/uploads\/2022\/01\/Restore-Post-Revisions-in-the-Classic-Editor-3.png\" alt=\"Restoring a Post Revision\" width=\"960\" height=\"442\" \/><\/p>\n<p>This revision shows the title and content have changed from one revision to the next. To restore this revision, all you have to do is click <strong>Restore This Revision<\/strong> in the upper right. <\/p>\n<h2>Where are WordPress Post Revisions Stored?<\/h2>\n<p>WordPress page and post revisions are great if you need them, but they also use space in your database, and that can slow down the overall performance of the site. Especially sites with large archives. Over time, the database gets larger with revisions you don\u2019t need. This can add up to a lot of revisions in your database. Fortunately, it\u2019s easy to manage WordPress revisions.\u00a0If you\u2019re sure you don\u2019t need them, it\u2019s best to clear them.<\/p>\n<p>WordPress post revisions are stored within your <a href=\"https:\/\/www.elegantthemes.com\/blog\/wordpress\/best-wordpress-database-optimization-plugins\">WordPress database<\/a>. You can access them in several ways.<\/p>\n<p><strong>Caution:<\/strong> Making changes to your database can be dangerous. Be sure you <a href=\"https:\/\/www.elegantthemes.com\/blog\/wordpress\/best-wordpress-backup-plugins\">have a recent backup<\/a> before making any changes.<\/p>\n<h3>Manage WordPress Revisions with phpMyAdmin<\/h3>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"with-border aligncenter size-full wp-image-165736\" src=\"https:\/\/www.elegantthemes.com\/blog\/wp-content\/uploads\/2022\/01\/Accessing-Post-Revisions-with-phpMyAdmin.png\" alt=\"Accessing Post Revisions with phpMyAdmin\" width=\"960\" height=\"238\" \/><\/p>\n<p>You can delete your revisions using <strong>SQL<\/strong>. If you have access to your <a href=\"https:\/\/www.elegantthemes.com\/blog\/wordpress\/what-is-cpanel-a-beginners-guide\">cPanel<\/a> in your web host\u2019s dashboard, select <a href=\"https:\/\/www.elegantthemes.com\/blog\/resources\/a-quick-guide-to-phpmyadmin-and-how-you-can-use-it\" rel=\"noopener\" target=\"_blank\">phpMyAdmin<\/a> under Databases. Yours might look different from mine, but they should work the same.<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"with-border aligncenter size-full wp-image-165734\" src=\"https:\/\/www.elegantthemes.com\/blog\/wp-content\/uploads\/2022\/01\/Accessing-Post-Revisions-with-phpMyAdmin-2.png\" alt=\"Accessing Post Revisions with phpMyAdmin\" width=\"959\" height=\"318\" \/><\/p>\n<p>Select the <strong>Databases<\/strong> tab in the phpMyAdmin dashboard, and then choose the database you\u2019d like to modify. Make note of the table prefix. You\u2019ll use this in the SQL command. For mine, it\u2019s blurred out a bit, but it will be whatever comes before the underscore. Such as \u201cwp21c9_\u201d.<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"with-border aligncenter size-full wp-image-165735\" src=\"https:\/\/www.elegantthemes.com\/blog\/wp-content\/uploads\/2022\/01\/Accessing-Post-Revisions-with-phpMyAdmin-3.png\" alt=\"Accessing Post Revisions with phpMyAdmin\" width=\"957\" height=\"464\" \/><\/p>\n<p>Select the <strong>SQL tab<\/strong>, paste this snippet into the field, and run the command.<\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">DELETE FROM yourtableprefix_posts WHERE post_type = \"revision\";<\/pre>\n<p>This will remove all the revisions in that database. Make sure to replace the example <em>yourtableprefix_<\/em> with yours.<\/p>\n<h3>Manage WordPress Revisions with FTP<\/h3>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"with-border aligncenter size-full wp-image-165733\" src=\"https:\/\/www.elegantthemes.com\/blog\/wp-content\/uploads\/2022\/01\/Accessing-Post-Revisions-with-FTP.png\" alt=\"Accessing Post Revisions with FTP\" width=\"960\" height=\"466\" \/><\/p>\n<p>You can also limit the number of revisions WordPress stores before they ever build up enough to slow down your site. For this, you will edit your site\u2019s <strong>wp-config.php<\/strong> file via an <a href=\"https:\/\/www.elegantthemes.com\/blog\/wordpress\/best-ftp-clients-for-wordpress\">FTP client<\/a>. <\/p>\n<p>Find the area of the file that is labeled \u201cWordPress Database Table Prefix\u201d, and paste these code snippets in it. This first snippet is what will limit the number of revisions your site keeps.<\/p>\n<pre class=\"brush: php; title: ; notranslate\" title=\"\">define('WP_POST_REVISIONS', 3); <\/pre>\n<p>By default, WordPress saves a revision every 60 seconds. This snippet lets you change that interval to something like 120 seconds. Be sure not to set the autosave interval too high, or you will be at a much higher risk of losing content and work.<\/p>\n<pre class=\"brush: php; title: ; notranslate\" title=\"\">define('AUTOSAVE_INTERVAL', 120);<\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"with-border aligncenter size-full wp-image-165732\" src=\"https:\/\/www.elegantthemes.com\/blog\/wp-content\/uploads\/2022\/01\/Accessing-Post-Revisions-with-FTP-2.png\" alt=\"Accessing Post Revisions with FTP\" width=\"960\" height=\"345\" \/><\/p>\n<p>And above, you can see what my wp-config.php file looks like after I added these snippets.<\/p>\n<p>And, if you want no revisions at all, you can disable them completely with this code. I don\u2019t recommend having <strong>zero<\/strong> revisions kept, however. That is a surefire way to lose content at some point.<\/p>\n<pre class=\"brush: php; title: ; notranslate\" title=\"\">define('WP_POST_REVISIONS', false);<\/pre>\n<p>As always, I recommend saving a backup before making changes, especially to PHP files. And if you\u2019re not comfortable editing your PGP files, you\u2019re not alone. It is safer to manage your WordPress revisions with a plugin.<\/p>\n<h3>Manage WordPress Revisions with a Plugin<\/h3>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"with-border aligncenter size-full wp-image-165739\" src=\"https:\/\/www.elegantthemes.com\/blog\/wp-content\/uploads\/2022\/01\/Managing-WordPress-Revisions-with-a-Plugin.png\" alt=\"WP-Optimize\" width=\"960\" height=\"309\" \/><\/p>\n<p>A plugin is the best method of managing revisions for most users. There are lots of good options, but I recommend <a href=\"https:\/\/wordpress.org\/plugins\/wp-optimize\/\">WP-Optimize<\/a>. It has lots of WordPress optimization options and the free version even includes scheduling removal of WordPress post revisions.<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"with-border aligncenter size-full wp-image-165737\" src=\"https:\/\/www.elegantthemes.com\/blog\/wp-content\/uploads\/2022\/01\/Managing-WordPress-Revisions-with-a-Plugin-2.png\" alt=\"WP-Optimize\" width=\"960\" height=\"464\" \/><\/p>\n<p>To optimize your post revisions, go to <strong>WP-Optimize<\/strong> &gt; <strong>Database<\/strong> in the WordPress dashboard. This automatically opens the <strong>Optimizations<\/strong> tab. Check <strong>Clean All Post Revisions<\/strong> and click <strong>Run Optimizer<\/strong>. On my test site, I have 1,087 post revisions in my database. And right now, I don\u2019t need <em>any<\/em> of them, so they\u2019re just taking up space.<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"with-border aligncenter size-full wp-image-165738\" src=\"https:\/\/www.elegantthemes.com\/blog\/wp-content\/uploads\/2022\/01\/Managing-WordPress-Revisions-with-a-Plugin-3.png\" alt=\"WP-Optimize\" width=\"961\" height=\"705\" \/><\/p>\n<p>You can also schedule the clean-up to run automatically. Schedule it to run daily or weekly, every two weeks, or even monthly if you want a longer buffer period. Go to the <strong>Settings tab<\/strong> in the <strong>WP-Optimize<\/strong> &gt; <strong>Database<\/strong> settings. Under <strong>Schedule Clean-up Settings<\/strong>, check to <strong>Enable Scheduled Clean-up and Optimization<\/strong>. Choose the <strong>schedule type<\/strong> (weekly is the default setting). Check <strong>Clean All Post Revisions<\/strong> and <strong>save<\/strong> your settings.<\/p>\n<h2>Conclusion<\/h2>\n<p>It is not hard to manage WordPress revisions to optimize your site performance. It\u2019s good to have a few to restore when necessary, but too many can take up space in your WordPress database, and as we said, if that continues unchecked, it can have an impact on your site\u2019s performance. Fortunately, there are several options to manage your WordPress revisions. Remember, if you\u2019re not comfortable heading into your PHP files, that\u2019s fine. A simple optimization plugin is the best option for most users anyway.<\/p>\n<p><strong>We want to hear from you. Do you use any of these methods to manage your post revisions? Let us know about your experience in the comments. <\/strong><\/p>\n<p><em>Featured Image via hanss \/\u00a0shutterstock.com<\/em><\/p>\n<p><span class=\"et_social_bottom_trigger\" \/>\n<\/div>\n<p>[ad_2]<br \/>\n<br \/><a href=\"https:\/\/www.elegantthemes.com\/blog\/wordpress\/how-to-manage-wordpress-revisions-to-optimize-site-performance\">Source link <\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] When you save a draft or update a post, WordPress stores a copy of the changes from the previous version. This feature is helpful if you ever need to revert to a previous version of your content, but these revisions take space in your database. If you have a lot of revisions, this can [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[529],"tags":[],"class_list":["post-811809","post","type-post","status-publish","format-standard","hentry","category-wordpress"],"_links":{"self":[{"href":"https:\/\/www.lafactory.com\/blog\/en\/wp-json\/wp\/v2\/posts\/811809","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.lafactory.com\/blog\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.lafactory.com\/blog\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.lafactory.com\/blog\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.lafactory.com\/blog\/en\/wp-json\/wp\/v2\/comments?post=811809"}],"version-history":[{"count":0,"href":"https:\/\/www.lafactory.com\/blog\/en\/wp-json\/wp\/v2\/posts\/811809\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.lafactory.com\/blog\/en\/wp-json\/wp\/v2\/media?parent=811809"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.lafactory.com\/blog\/en\/wp-json\/wp\/v2\/categories?post=811809"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.lafactory.com\/blog\/en\/wp-json\/wp\/v2\/tags?post=811809"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}