{"id":6719,"date":"2022-05-23T08:13:49","date_gmt":"2022-05-23T08:13:49","guid":{"rendered":"https:\/\/wpx.net\/kb\/?post_type=ht_kb&p=6719"},"modified":"2025-07-18T10:52:54","modified_gmt":"2025-07-18T10:52:54","slug":"how-to-optimize-the-database","status":"publish","type":"ht_kb","link":"https:\/\/wpx.net\/kb\/how-to-optimize-the-database\/","title":{"rendered":"How to optimize the database?"},"content":{"rendered":"\n

In this article, you will learn how you can optimize a database in a few really simple steps. This may help with ongoing issues that your site experience such as being slow or removing unnecessary content (spam comments, duplicated data, etc.)<\/p>\n\n\n\n

Step 1. Install and activate the WP-sweep plugin.<\/h2>\n\n\n\n

To install the plugin, you can search for it straight in your WordPress Dashboard (you can log in to your backend area by adding \/wp-admin<\/strong> at the end of your website’s URL, eg. https:\/\/mywebsite.com\/wp-admin<\/strong>). <\/p>\n\n\n\n

Click on Add New<\/strong> (1) in your Plugins <\/strong>menu, then type wp-sweep <\/strong>(2) into the search bar. Press Install<\/strong> Now<\/strong> (3) <\/strong>next to the plugin,<\/strong> and then activate.<\/p>\n\n\n\n

\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n

Once it\u2019s activated, you can find the plugin\u2019s settings in the Tools<\/strong> area of your WordPress dashboard and select Sweep<\/strong>.<\/p>\n\n\n\n

\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n

Step 2. Optimize the database.<\/h2>\n\n\n\n

Before you do any sweep we would highly recommend backing up your database<\/a> first as the optimization done by the plugin is irreversible.<\/p>\n\n\n\n

Once you’re in the wp-sweep plugin options you will find a Database Sweep<\/strong> (1) option at the bottom of the page. All you need to do is to press the Sweep button<\/strong> (2):<\/p>\n\n\n\n

\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n

If you’re wondering what exactly will be cleaned up by the plugin, please read below:<\/p>\n\n\n\n

    \n
  • Revisions<\/li>\n\n\n\n
  • Auto drafts<\/li>\n\n\n\n
  • Deleted comments<\/li>\n\n\n\n
  • Unapproved comments<\/li>\n\n\n\n
  • Spammed comments<\/li>\n\n\n\n
  • Deleted comments<\/li>\n\n\n\n
  • Orphaned post meta<\/li>\n\n\n\n
  • Orphaned comment meta<\/li>\n\n\n\n
  • Orphaned user meta<\/li>\n\n\n\n
  • Orphaned term meta<\/li>\n\n\n\n
  • Orphan term relationships<\/li>\n\n\n\n
  • Unused terms<\/li>\n\n\n\n
  • Duplicated post meta<\/li>\n\n\n\n
  • Duplicated comment meta<\/li>\n\n\n\n
  • Duplicated user meta<\/li>\n\n\n\n
  • Duplicated term meta<\/li>\n\n\n\n
  • Transient options<\/li>\n\n\n\n
  • Optimizes database tables<\/li>\n\n\n\n
  • oEmbed caches in post meta<\/li>\n<\/ul>\n\n\n\n

    Once the plugin indicates that the procedure is complete – congratulations! You’ve now optimized your database.<\/p>\n\n\n\n

    If you get stuck with anything discussed on this page, please get in touch with WPX Support Team via live chat (use the bottom right-hand widget) and they will respond and help within 30 seconds or less.<\/p>\n","protected":false},"excerpt":{"rendered":"

    In this article, you will learn how you can optimize a database in a few really simple steps. This may help with ongoing issues that your site experience such as being slow or removing unnecessary content (spam comments, duplicated data, etc.) Step 1. Install and activate the WP-sweep plugin. To…<\/p>\n","protected":false},"author":2,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_editorskit_title_hidden":false,"_editorskit_reading_time":2,"_editorskit_is_block_options_detached":false,"_editorskit_block_options_position":"{}","inline_featured_image":false,"footnotes":""},"ht-kb-category":[30],"ht-kb-tag":[],"class_list":["post-6719","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-website-help"],"_links":{"self":[{"href":"https:\/\/wpx.net\/kb\/wp-json\/wp\/v2\/ht-kb\/6719","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wpx.net\/kb\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/wpx.net\/kb\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/wpx.net\/kb\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/wpx.net\/kb\/wp-json\/wp\/v2\/comments?post=6719"}],"version-history":[{"count":10,"href":"https:\/\/wpx.net\/kb\/wp-json\/wp\/v2\/ht-kb\/6719\/revisions"}],"predecessor-version":[{"id":13651,"href":"https:\/\/wpx.net\/kb\/wp-json\/wp\/v2\/ht-kb\/6719\/revisions\/13651"}],"wp:attachment":[{"href":"https:\/\/wpx.net\/kb\/wp-json\/wp\/v2\/media?parent=6719"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/wpx.net\/kb\/wp-json\/wp\/v2\/ht-kb-category?post=6719"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/wpx.net\/kb\/wp-json\/wp\/v2\/ht-kb-tag?post=6719"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}