{"id":114,"date":"2020-09-24T15:42:01","date_gmt":"2020-09-24T13:42:01","guid":{"rendered":"https:\/\/astuces-wp.com\/?p=114"},"modified":"2022-03-13T12:11:08","modified_gmt":"2022-03-13T11:11:08","slug":"optimiser-bdd-wordpress","status":"publish","type":"post","link":"https:\/\/magali-colas.fr\/astuces-wordpress\/optimiser-bdd-wordpress\/","title":{"rendered":"Comment all\u00e9ger et optimiser sa base de donn\u00e9es WordPress&nbsp;?"},"content":{"rendered":"<h2>Supprimer les r\u00e9visions de post<\/h2>\n<pre>DELETE FROM wp_posts WHERE post_type = \"revision\";<\/pre>\n<h2>Supprimer les commentaires spam<\/h2>\n<pre>DELETE FROM wp_comments WHERE comment_approved = '0';<\/pre>\n<h2>Supprimer les posts en corbeille<\/h2>\n<p>Voici la requ\u00eate SQL qui permet de supprimer les articles pr\u00e9sents en corbeille. Vous pouvez modifier la requ\u00eate en fonction des status (brouillon etc).<\/p>\n<pre>DELETE <span class=\"kwd\">FROM<\/span><span class=\"pln\"> wp_posts\r\n<\/span><\/pre>\n<p>Ce bou de code se place dans le fichier functions.php et permet de ne pas stocker les articles en corbeille :<\/p>\n<pre><span class=\"kwd\">WHERE<\/span><span class=\"pln\"> post_status <\/span><span class=\"pun\">=<\/span> <span class=\"pun\">\u2018<\/span><span class=\"pln\">trash<\/span><span class=\"pun\">\u2019<\/span>\r\ndefine( 'EMPTY_TRASH_DAYS', 0 ); \/\/ Zero days<\/pre>\n<h2>Supprimer les transients<\/h2>\n<pre>DELETE FROM `wp_options` WHERE `option_name` LIKE ('%\\_transient\\_%');<\/pre>\n<h2>Supprimer toutes les \u00e9tiquettes \/ cat\u00e9gories inutiles<\/h2>\n<p>Afin de ne pas surcharger les tables :<\/p>\n<ul>\n<li>wp_terms<\/li>\n<li>wp_termmeta<\/li>\n<li>wp_term_taxonomy<\/li>\n<li>wp_term_relationships<\/li>\n<\/ul>\n<p>Il est recommand\u00e9 de ne pas cr\u00e9er des \u00e9tiquettes et cat\u00e9gories pour chaque article. Ce conseil s&rsquo;applique aussi pour votre strat\u00e9gie SEO.<\/p>\n<h3>A lire aussi : <\/h3>\n<article id=\"post-114\" class=\"categ_loop col-md-4\">\n\t\t<div class=\"widget_appear\">\n\t\t\t\t\t<a href=\"https:\/\/magali-colas.fr\/astuces-wordpress\/stopper-creation-etiquettes\/\"><h2 class=\"category_title \">Comment stopper la cr\u00e9ation d\u2019\u00e9tiquettes&nbsp;?<\/h3><\/a>\n\t\t\t\t\t\t\t\t\t<div class=\"infos-publications\">\t\t\t\n\t\t\t\t\t\t\t24 septembre 2020 \u00e0 15:42\t\t\t\t\t<\/div>\t\n\t\t\t\t\t\t<img src='https:\/\/magali-colas.fr\/astuces-wordpress\/wp-content\/uploads\/2020\/06\/etiquettes_wordpress-150x150.jpg'>\n\t\t\t\t\t\t\t\t\t\t<p class=\"description\">Les tags ou \u00e9tiquettes sont tr\u00e8s utiles dans WordPress. Ils aident au maillage interne mais si cet...<\/p>\n\n\n\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t<\/div>\n\t\t\t<\/article> \n","protected":false},"excerpt":{"rendered":"<p>Supprimer les r\u00e9visions de post DELETE FROM wp_posts WHERE post_type = \u00ab\u00a0revision\u00a0\u00bb; Supprimer les commentaires spam DELETE FROM wp_comments WHERE comment_approved = &lsquo;0&rsquo;; Supprimer les posts en corbeille Voici la requ\u00eate SQL qui permet de supprimer les articles pr\u00e9sents en corbeille. Vous pouvez modifier la requ\u00eate en fonction des status (brouillon etc). DELETE FROM wp_posts [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":135,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[12],"class_list":["post-114","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-seo","tag-rapidite"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Comment all\u00e9ger et optimiser sa base de donn\u00e9es WordPress ?<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/magali-colas.fr\/astuces-wordpress\/optimiser-bdd-wordpress\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Comment all\u00e9ger et optimiser sa base de donn\u00e9es WordPress ?\" \/>\n<meta property=\"og:description\" content=\"Supprimer les r\u00e9visions de post DELETE FROM wp_posts WHERE post_type = &quot;revision&quot;; Supprimer les commentaires spam DELETE FROM wp_comments WHERE comment_approved = &#039;0&#039;; Supprimer les posts en corbeille Voici la requ\u00eate SQL qui permet de supprimer les articles pr\u00e9sents en corbeille. Vous pouvez modifier la requ\u00eate en fonction des status (brouillon etc). DELETE FROM wp_posts [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/magali-colas.fr\/astuces-wordpress\/optimiser-bdd-wordpress\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-09-24T13:42:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-03-13T11:11:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/magali-colas.fr\/astuces-wordpress\/wp-content\/uploads\/2020\/09\/requete_sql.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"960\" \/>\n\t<meta property=\"og:image:height\" content=\"525\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Lyanna\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Lyanna\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/magali-colas.fr\/astuces-wordpress\/optimiser-bdd-wordpress\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/magali-colas.fr\/astuces-wordpress\/optimiser-bdd-wordpress\/\"},\"author\":{\"name\":\"Lyanna\",\"@id\":\"https:\/\/magali-colas.fr\/astuces-wordpress\/#\/schema\/person\/f7cb41098a46b2339b7bf590e8aa516a\"},\"headline\":\"Comment all\u00e9ger et optimiser sa base de donn\u00e9es WordPress&nbsp;?\",\"datePublished\":\"2020-09-24T13:42:01+00:00\",\"dateModified\":\"2022-03-13T11:11:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/magali-colas.fr\/astuces-wordpress\/optimiser-bdd-wordpress\/\"},\"wordCount\":132,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/magali-colas.fr\/astuces-wordpress\/optimiser-bdd-wordpress\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/magali-colas.fr\/astuces-wordpress\/wp-content\/uploads\/2020\/09\/requete_sql.jpg\",\"keywords\":[\"Rapidit\u00e9\"],\"articleSection\":[\"SEO\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/magali-colas.fr\/astuces-wordpress\/optimiser-bdd-wordpress\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/magali-colas.fr\/astuces-wordpress\/optimiser-bdd-wordpress\/\",\"url\":\"https:\/\/magali-colas.fr\/astuces-wordpress\/optimiser-bdd-wordpress\/\",\"name\":\"Comment all\u00e9ger et optimiser sa base de donn\u00e9es WordPress ?\",\"isPartOf\":{\"@id\":\"https:\/\/magali-colas.fr\/astuces-wordpress\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/magali-colas.fr\/astuces-wordpress\/optimiser-bdd-wordpress\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/magali-colas.fr\/astuces-wordpress\/optimiser-bdd-wordpress\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/magali-colas.fr\/astuces-wordpress\/wp-content\/uploads\/2020\/09\/requete_sql.jpg\",\"datePublished\":\"2020-09-24T13:42:01+00:00\",\"dateModified\":\"2022-03-13T11:11:08+00:00\",\"author\":{\"@id\":\"https:\/\/magali-colas.fr\/astuces-wordpress\/#\/schema\/person\/f7cb41098a46b2339b7bf590e8aa516a\"},\"breadcrumb\":{\"@id\":\"https:\/\/magali-colas.fr\/astuces-wordpress\/optimiser-bdd-wordpress\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/magali-colas.fr\/astuces-wordpress\/optimiser-bdd-wordpress\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/magali-colas.fr\/astuces-wordpress\/optimiser-bdd-wordpress\/#primaryimage\",\"url\":\"https:\/\/magali-colas.fr\/astuces-wordpress\/wp-content\/uploads\/2020\/09\/requete_sql.jpg\",\"contentUrl\":\"https:\/\/magali-colas.fr\/astuces-wordpress\/wp-content\/uploads\/2020\/09\/requete_sql.jpg\",\"width\":960,\"height\":525},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/magali-colas.fr\/astuces-wordpress\/optimiser-bdd-wordpress\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\ud83c\udfe0 Accueil\",\"item\":\"https:\/\/magali-colas.fr\/astuces-wordpress\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Rapidit\u00e9\",\"item\":\"https:\/\/magali-colas.fr\/astuces-wordpress\/tag\/rapidite\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Comment all\u00e9ger et optimiser sa base de donn\u00e9es WordPress&nbsp;?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/magali-colas.fr\/astuces-wordpress\/#website\",\"url\":\"https:\/\/magali-colas.fr\/astuces-wordpress\/\",\"name\":\"\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/magali-colas.fr\/astuces-wordpress\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/magali-colas.fr\/astuces-wordpress\/#\/schema\/person\/f7cb41098a46b2339b7bf590e8aa516a\",\"name\":\"Lyanna\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/magali-colas.fr\/astuces-wordpress\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/4e361b30ec79a25d91a54b45254a5fd94f2c88bcf72f01c85a103a89bbec68f4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/4e361b30ec79a25d91a54b45254a5fd94f2c88bcf72f01c85a103a89bbec68f4?s=96&d=mm&r=g\",\"caption\":\"Lyanna\"},\"sameAs\":[\"https:\/\/astuces-wp.com\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Comment all\u00e9ger et optimiser sa base de donn\u00e9es WordPress ?","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/magali-colas.fr\/astuces-wordpress\/optimiser-bdd-wordpress\/","og_locale":"fr_FR","og_type":"article","og_title":"Comment all\u00e9ger et optimiser sa base de donn\u00e9es WordPress ?","og_description":"Supprimer les r\u00e9visions de post DELETE FROM wp_posts WHERE post_type = \"revision\"; Supprimer les commentaires spam DELETE FROM wp_comments WHERE comment_approved = '0'; Supprimer les posts en corbeille Voici la requ\u00eate SQL qui permet de supprimer les articles pr\u00e9sents en corbeille. Vous pouvez modifier la requ\u00eate en fonction des status (brouillon etc). DELETE FROM wp_posts [&hellip;]","og_url":"https:\/\/magali-colas.fr\/astuces-wordpress\/optimiser-bdd-wordpress\/","article_published_time":"2020-09-24T13:42:01+00:00","article_modified_time":"2022-03-13T11:11:08+00:00","og_image":[{"width":960,"height":525,"url":"https:\/\/magali-colas.fr\/astuces-wordpress\/wp-content\/uploads\/2020\/09\/requete_sql.jpg","type":"image\/jpeg"}],"author":"Lyanna","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Lyanna","Dur\u00e9e de lecture estim\u00e9e":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/magali-colas.fr\/astuces-wordpress\/optimiser-bdd-wordpress\/#article","isPartOf":{"@id":"https:\/\/magali-colas.fr\/astuces-wordpress\/optimiser-bdd-wordpress\/"},"author":{"name":"Lyanna","@id":"https:\/\/magali-colas.fr\/astuces-wordpress\/#\/schema\/person\/f7cb41098a46b2339b7bf590e8aa516a"},"headline":"Comment all\u00e9ger et optimiser sa base de donn\u00e9es WordPress&nbsp;?","datePublished":"2020-09-24T13:42:01+00:00","dateModified":"2022-03-13T11:11:08+00:00","mainEntityOfPage":{"@id":"https:\/\/magali-colas.fr\/astuces-wordpress\/optimiser-bdd-wordpress\/"},"wordCount":132,"commentCount":0,"image":{"@id":"https:\/\/magali-colas.fr\/astuces-wordpress\/optimiser-bdd-wordpress\/#primaryimage"},"thumbnailUrl":"https:\/\/magali-colas.fr\/astuces-wordpress\/wp-content\/uploads\/2020\/09\/requete_sql.jpg","keywords":["Rapidit\u00e9"],"articleSection":["SEO"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/magali-colas.fr\/astuces-wordpress\/optimiser-bdd-wordpress\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/magali-colas.fr\/astuces-wordpress\/optimiser-bdd-wordpress\/","url":"https:\/\/magali-colas.fr\/astuces-wordpress\/optimiser-bdd-wordpress\/","name":"Comment all\u00e9ger et optimiser sa base de donn\u00e9es WordPress ?","isPartOf":{"@id":"https:\/\/magali-colas.fr\/astuces-wordpress\/#website"},"primaryImageOfPage":{"@id":"https:\/\/magali-colas.fr\/astuces-wordpress\/optimiser-bdd-wordpress\/#primaryimage"},"image":{"@id":"https:\/\/magali-colas.fr\/astuces-wordpress\/optimiser-bdd-wordpress\/#primaryimage"},"thumbnailUrl":"https:\/\/magali-colas.fr\/astuces-wordpress\/wp-content\/uploads\/2020\/09\/requete_sql.jpg","datePublished":"2020-09-24T13:42:01+00:00","dateModified":"2022-03-13T11:11:08+00:00","author":{"@id":"https:\/\/magali-colas.fr\/astuces-wordpress\/#\/schema\/person\/f7cb41098a46b2339b7bf590e8aa516a"},"breadcrumb":{"@id":"https:\/\/magali-colas.fr\/astuces-wordpress\/optimiser-bdd-wordpress\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/magali-colas.fr\/astuces-wordpress\/optimiser-bdd-wordpress\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/magali-colas.fr\/astuces-wordpress\/optimiser-bdd-wordpress\/#primaryimage","url":"https:\/\/magali-colas.fr\/astuces-wordpress\/wp-content\/uploads\/2020\/09\/requete_sql.jpg","contentUrl":"https:\/\/magali-colas.fr\/astuces-wordpress\/wp-content\/uploads\/2020\/09\/requete_sql.jpg","width":960,"height":525},{"@type":"BreadcrumbList","@id":"https:\/\/magali-colas.fr\/astuces-wordpress\/optimiser-bdd-wordpress\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\ud83c\udfe0 Accueil","item":"https:\/\/magali-colas.fr\/astuces-wordpress\/"},{"@type":"ListItem","position":2,"name":"Rapidit\u00e9","item":"https:\/\/magali-colas.fr\/astuces-wordpress\/tag\/rapidite\/"},{"@type":"ListItem","position":3,"name":"Comment all\u00e9ger et optimiser sa base de donn\u00e9es WordPress&nbsp;?"}]},{"@type":"WebSite","@id":"https:\/\/magali-colas.fr\/astuces-wordpress\/#website","url":"https:\/\/magali-colas.fr\/astuces-wordpress\/","name":"","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/magali-colas.fr\/astuces-wordpress\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/magali-colas.fr\/astuces-wordpress\/#\/schema\/person\/f7cb41098a46b2339b7bf590e8aa516a","name":"Lyanna","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/magali-colas.fr\/astuces-wordpress\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/4e361b30ec79a25d91a54b45254a5fd94f2c88bcf72f01c85a103a89bbec68f4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4e361b30ec79a25d91a54b45254a5fd94f2c88bcf72f01c85a103a89bbec68f4?s=96&d=mm&r=g","caption":"Lyanna"},"sameAs":["https:\/\/astuces-wp.com"]}]}},"_links":{"self":[{"href":"https:\/\/magali-colas.fr\/astuces-wordpress\/wp-json\/wp\/v2\/posts\/114","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/magali-colas.fr\/astuces-wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/magali-colas.fr\/astuces-wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/magali-colas.fr\/astuces-wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/magali-colas.fr\/astuces-wordpress\/wp-json\/wp\/v2\/comments?post=114"}],"version-history":[{"count":0,"href":"https:\/\/magali-colas.fr\/astuces-wordpress\/wp-json\/wp\/v2\/posts\/114\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/magali-colas.fr\/astuces-wordpress\/wp-json\/wp\/v2\/media\/135"}],"wp:attachment":[{"href":"https:\/\/magali-colas.fr\/astuces-wordpress\/wp-json\/wp\/v2\/media?parent=114"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/magali-colas.fr\/astuces-wordpress\/wp-json\/wp\/v2\/categories?post=114"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/magali-colas.fr\/astuces-wordpress\/wp-json\/wp\/v2\/tags?post=114"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}