{"id":327,"date":"2016-12-09T05:19:33","date_gmt":"2016-12-09T05:19:33","guid":{"rendered":"https:\/\/danielepais.com\/journal\/?p=327"},"modified":"2022-02-03T13:47:53","modified_gmt":"2022-02-03T06:47:53","slug":"3-simple-tweaks-to-shrink-your-wordpress-database-size","status":"publish","type":"post","link":"https:\/\/danielepais.com\/journal\/3-simple-tweaks-to-shrink-your-wordpress-database-size\/","title":{"rendered":"3 simple Tweaks to shrink your WordPress database size"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/ywAAAAAAQABAAACAUwAOw==\" fifu-lazy=\"1\" fifu-data-sizes=\"auto\" fifu-data-srcset=\"https:\/\/wp.fifu.app\/danielepais.com\/aHR0cHM6Ly9kYW5pZWxlcGFpcy5jb20vam91cm5hbC93cC1jb250ZW50L3VwbG9hZHMvMjAxNi8xMi9jb3Zlci03MDB4MTg3LnBuZw\/6872bd120686\/wordpress-tweaks-featured.webp?p=327&w=75&h=0&c=0 75w, https:\/\/wp.fifu.app\/danielepais.com\/aHR0cHM6Ly9kYW5pZWxlcGFpcy5jb20vam91cm5hbC93cC1jb250ZW50L3VwbG9hZHMvMjAxNi8xMi9jb3Zlci03MDB4MTg3LnBuZw\/75c4851aa90c\/wordpress-tweaks-featured.webp?p=327&w=100&h=0&c=0 100w, https:\/\/wp.fifu.app\/danielepais.com\/aHR0cHM6Ly9kYW5pZWxlcGFpcy5jb20vam91cm5hbC93cC1jb250ZW50L3VwbG9hZHMvMjAxNi8xMi9jb3Zlci03MDB4MTg3LnBuZw\/e4aa7bddc308\/wordpress-tweaks-featured.webp?p=327&w=150&h=0&c=0 150w, https:\/\/wp.fifu.app\/danielepais.com\/aHR0cHM6Ly9kYW5pZWxlcGFpcy5jb20vam91cm5hbC93cC1jb250ZW50L3VwbG9hZHMvMjAxNi8xMi9jb3Zlci03MDB4MTg3LnBuZw\/ea8774c087ab\/wordpress-tweaks-featured.webp?p=327&w=240&h=0&c=0 240w, https:\/\/wp.fifu.app\/danielepais.com\/aHR0cHM6Ly9kYW5pZWxlcGFpcy5jb20vam91cm5hbC93cC1jb250ZW50L3VwbG9hZHMvMjAxNi8xMi9jb3Zlci03MDB4MTg3LnBuZw\/0be7aea29e2b\/wordpress-tweaks-featured.webp?p=327&w=320&h=0&c=0 320w, https:\/\/wp.fifu.app\/danielepais.com\/aHR0cHM6Ly9kYW5pZWxlcGFpcy5jb20vam91cm5hbC93cC1jb250ZW50L3VwbG9hZHMvMjAxNi8xMi9jb3Zlci03MDB4MTg3LnBuZw\/69e84d18a597\/wordpress-tweaks-featured.webp?p=327&w=500&h=0&c=0 500w, https:\/\/wp.fifu.app\/danielepais.com\/aHR0cHM6Ly9kYW5pZWxlcGFpcy5jb20vam91cm5hbC93cC1jb250ZW50L3VwbG9hZHMvMjAxNi8xMi9jb3Zlci03MDB4MTg3LnBuZw\/b8b4e66d3c46\/wordpress-tweaks-featured.webp?p=327&w=640&h=0&c=0 640w, https:\/\/wp.fifu.app\/danielepais.com\/aHR0cHM6Ly9kYW5pZWxlcGFpcy5jb20vam91cm5hbC93cC1jb250ZW50L3VwbG9hZHMvMjAxNi8xMi9jb3Zlci03MDB4MTg3LnBuZw\/d6730daecc62\/wordpress-tweaks-featured.webp?p=327&w=800&h=0&c=0 800w, https:\/\/wp.fifu.app\/danielepais.com\/aHR0cHM6Ly9kYW5pZWxlcGFpcy5jb20vam91cm5hbC93cC1jb250ZW50L3VwbG9hZHMvMjAxNi8xMi9jb3Zlci03MDB4MTg3LnBuZw\/bbdc83b1edc3\/wordpress-tweaks-featured.webp?p=327&w=1024&h=0&c=0 1024w, https:\/\/wp.fifu.app\/danielepais.com\/aHR0cHM6Ly9kYW5pZWxlcGFpcy5jb20vam91cm5hbC93cC1jb250ZW50L3VwbG9hZHMvMjAxNi8xMi9jb3Zlci03MDB4MTg3LnBuZw\/11a71e10ef9e\/wordpress-tweaks-featured.webp?p=327&w=1280&h=0&c=0 1280w, https:\/\/wp.fifu.app\/danielepais.com\/aHR0cHM6Ly9kYW5pZWxlcGFpcy5jb20vam91cm5hbC93cC1jb250ZW50L3VwbG9hZHMvMjAxNi8xMi9jb3Zlci03MDB4MTg3LnBuZw\/3c46bb334522\/wordpress-tweaks-featured.webp?p=327&w=1600&h=0&c=0 1600w\" class=\"aligncenter\" fifu-data-src=\"https:\/\/wp.fifu.app\/danielepais.com\/aHR0cHM6Ly9kYW5pZWxlcGFpcy5jb20vam91cm5hbC93cC1jb250ZW50L3VwbG9hZHMvMjAxNi8xMi9jb3Zlci03MDB4MTg3LnBuZw\/5a12adcb8dbb\/wordpress-tweaks-featured.webp?p=327\" sizes=\"(max-width: 640px) 100vw, 640px\" srcset=\"https:\/\/wp.fifu.app\/danielepais.com\/aHR0cHM6Ly9kYW5pZWxlcGFpcy5jb20vam91cm5hbC93cC1jb250ZW50L3VwbG9hZHMvMjAxNi8xMi9jb3Zlci03MDB4MTg3LnBuZw\/5a12adcb8dbb\/wordpress-tweaks-featured.webp?p=327 700w, https:\/\/danielepais.com\/journal\/wp-content\/uploads\/2016\/12\/cover-300x80.png 300w, https:\/\/danielepais.com\/journal\/wp-content\/uploads\/2016\/12\/cover-768x205.png 768w, https:\/\/danielepais.com\/journal\/wp-content\/uploads\/2016\/12\/cover.png 1301w\" alt=\"WordPress Tweaks issue 1\" width=\"640\" height=\"171\" \/><\/p>\n<p>So you have a huge <a href=\"https:\/\/danielepais.com\/journal\/blog-post-ideas-for-new-bloggers\/\">blog<\/a> and your site pages and posts start taking a bit longer to load and you might ask yourself how could I possibly speed it up? Sure, many of you are thinking of Cache Management Plugins and so on but today I am not here for that kind of stuff. Adding more plugins also means adding extra workload for your database, not to mention adding extra php and MySql scripts that if not well written could be in the worst case scenario even cause of malware infection.<\/p>\n<p>Today I am here to give out a few tweaks that will simplify your tasks, reduce your <a href=\"https:\/\/danielepais.com\/journal\/building-custom-themes-for-wordpress\/\">WordPress<\/a> database size and workload and ultimately make your life a lot easier.<\/p>\n<p><strong>DISCLAIMER:<\/strong><br \/>\nThis tweaks are intended for people that is accustomed on editing PHP <a href=\"https:\/\/danielepais.com\/journal\/encrypt-files-on-linux-using-veracrypt\/\">files<\/a> and have an understanding of how important it is to always <a href=\"https:\/\/danielepais.com\/journal\/wordpress-backup-and-restore-fundamentals\/\">BACKUP<\/a> a file prior to do some editing on top.<\/p>\n<p>Having said that, let&#8217;s go to the meat and potatoes of today WordPress good hacking.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6ac7fe77a75b3\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #18bc9c;color:#18bc9c\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #18bc9c;color:#18bc9c\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6ac7fe77a75b3\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/danielepais.com\/journal\/3-simple-tweaks-to-shrink-your-wordpress-database-size\/#Hack_1_%E2%80%93_Revisions\" >Hack #1 &#8211; Revisions<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/danielepais.com\/journal\/3-simple-tweaks-to-shrink-your-wordpress-database-size\/#Hack_2_%E2%80%93_Trash_Can\" >Hack #2 &#8211;\u00a0Trash Can<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/danielepais.com\/journal\/3-simple-tweaks-to-shrink-your-wordpress-database-size\/#Hack_3_%E2%80%93_Image_Overwrite\" >Hack #3 &#8211;\u00a0Image Overwrite<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"Hack_1_%E2%80%93_Revisions\"><\/span>Hack #1 &#8211; Revisions<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>-Editing required on page:<\/strong> \u00a0<code>wp-config.php<br \/>\n <\/code><strong>-Time required:<\/strong>\u00a0(between 1 and 5 minutes)<\/p>\n<p>Every time you make some changes to either a post or a page WordPress create a revision of that post or page thus creating multiple entry on database with different timestamp. Now, unless you are a &#8220;collector&#8221; of old revisions for that post you have written 8 weeks ago you probably don&#8217;t need most of the revisions that are occupying vital estate in your already heavy Database. So let&#8217;s say you want to limit your revisions to the last 2, just to be sure that if you make some adjustments today and in a week time from now you find out that something is wrong you still have a good number of revisions to revert the article back to the old version.<\/p>\n<p style=\"text-align: left;\">To do so, head to your wp-config.php file and add this line of code: <code>define('WP_POST_REVISIONS', 3);<\/code><\/p>\n<p>For those of you who don&#8217;t actually want any of the revisions to appear on the database you can disable the feature by adding this line of code:<br \/>\n<code>define( 'WP_POST_REVISIONS', false );<\/code><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Hack_2_%E2%80%93_Trash_Can\"><\/span>Hack #2 &#8211;\u00a0Trash Can<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>-Editing required on page:<\/strong> \u00a0<code>wp-config.php<br \/>\n<\/code><strong>-Time required:<\/strong>\u00a0(between 1 and 5 minutes)<\/p>\n<p>WordPress stores in the database posts, articles, pages, comments and attachments that have been trashed, however you can reduce the size of your database by controlling the number of days this will stay in the trash can before being permanently removed. As a default WordPress sets 30 days, you can easily change it to a number of your choice by adding this line of code:<br \/>\n<code>define( 'EMPTY_TRASH_DAYS', 5 );<\/code><\/p>\n<p>in this case you have set the database to keep the files in the trash can for 5 days in total.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Hack_3_%E2%80%93_Image_Overwrite\"><\/span>Hack #3 &#8211;\u00a0Image Overwrite<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>-Editing required on page:<\/strong> \u00a0<code>wp-config.php<br \/>\n<\/code><strong>-Time required:<\/strong>\u00a0(between 1 and 5 minutes)<\/p>\n<p>WordPress is set to create a copy of an image every time this is edited, so sometime you have the same image in multiple formats even if you are not using them. If you want, you can change this behaviour by telling WP to overwrite the original image instead of making copies so that you will have much less mess on your database and save some precious space especially if you run an ecommerce site where you have hundreds of products and each of them have multiple photos.<br \/>\nHere is the line of code to add:<br \/>\n<code>define( 'IMAGE_EDIT_OVERWRITE', true );<\/code><\/p>\n<p>\nHopefully if you apply any of this 3 easy tweaks you have now a more responsive database and a better page loading time. Please remember to always make an FTP backup of your wp-config.php file prior to mess with it or if this is your first time editing php core files, make a trial on a test site that you might host on your machine rather than onto your or your \/ your client live website.<\/p>\n<p>That&#8217;s it for today, until next time, keep cool and do some good positive hacking on WordPress.<\/p>\n<p><strong>About the Author<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>So you have a huge blog and your site pages and posts start taking a bit longer to load and you might ask yourself how could I possibly speed it up? Sure, many of you are thinking of Cache Management Plugins and so on but today I am not here for that kind of stuff. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":338,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"fifu_image_url":"","fifu_image_alt":"","footnotes":""},"categories":[225,233],"tags":[177,236,238,237,235,213],"acf":[],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.8 - aioseo.com -->\n\t<meta name=\"description\" content=\"So you have a huge blog and your site pages and posts start taking a bit longer to load and you might ask yourself how could I possibly speed it up?\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Daniele Pais\"\/>\n\t<meta name=\"google-site-verification\" content=\"googleb91c9505ed997b99\" \/>\n\t<meta name=\"msvalidate.01\" content=\"AD1C96C338E051848BE08C67378B20CA\" \/>\n\t<meta name=\"keywords\" content=\"coding,database,performance,speed,tweaks,wordpress,design\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/danielepais.com\/journal\/3-simple-tweaks-to-shrink-your-wordpress-database-size\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.8\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Daniele Pais Blog\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"3 simple Tweaks to shrink your WordPress database size | Phuket Web Design\" \/>\n\t\t<meta property=\"og:description\" content=\"So you have a huge blog and your site pages and posts start taking a bit longer to load and you might ask yourself how could I possibly speed it up?\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/danielepais.com\/journal\/3-simple-tweaks-to-shrink-your-wordpress-database-size\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/danielepais.com\/journal\/wp-content\/uploads\/2016\/12\/featured.png\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/danielepais.com\/journal\/wp-content\/uploads\/2016\/12\/featured.png\" \/>\n\t\t<meta property=\"og:image:width\" content=\"566\" \/>\n\t\t<meta property=\"og:image:height\" content=\"205\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2016-12-09T05:19:33+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2022-02-03T06:47:53+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:site\" content=\"@daniele_pais\" \/>\n\t\t<meta name=\"twitter:title\" content=\"3 simple Tweaks to shrink your WordPress database size | Phuket Web Design\" \/>\n\t\t<meta name=\"twitter:description\" content=\"So you have a huge blog and your site pages and posts start taking a bit longer to load and you might ask yourself how could I possibly speed it up?\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/danielepais.com\/journal\/wp-content\/uploads\/2017\/10\/daniele-pais-digital-design.png\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/danielepais.com\\\/journal\\\/3-simple-tweaks-to-shrink-your-wordpress-database-size\\\/#article\",\"name\":\"3 simple Tweaks to shrink your WordPress database size | Phuket Web Design\",\"headline\":\"3 simple Tweaks to shrink your WordPress database size\",\"author\":{\"@id\":\"https:\\\/\\\/danielepais.com\\\/journal\\\/author\\\/_-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2--2\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/danielepais.com\\\/journal\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/danielepais.com\\\/journal\\\/wp-content\\\/uploads\\\/2016\\\/12\\\/featured.png\",\"width\":566,\"height\":205,\"caption\":\"WordPress Tweaks Featured\"},\"datePublished\":\"2016-12-09T05:19:33+07:00\",\"dateModified\":\"2022-02-03T13:47:53+07:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/danielepais.com\\\/journal\\\/3-simple-tweaks-to-shrink-your-wordpress-database-size\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/danielepais.com\\\/journal\\\/3-simple-tweaks-to-shrink-your-wordpress-database-size\\\/#webpage\"},\"articleSection\":\"Design, Wordpress, coding, database, performance, speed, tweaks, wordpress\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/danielepais.com\\\/journal\\\/3-simple-tweaks-to-shrink-your-wordpress-database-size\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/danielepais.com\\\/journal#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/danielepais.com\\\/journal\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/danielepais.com\\\/journal\\\/category\\\/web\\\/#listItem\",\"name\":\"Web\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/danielepais.com\\\/journal\\\/category\\\/web\\\/#listItem\",\"position\":2,\"name\":\"Web\",\"item\":\"https:\\\/\\\/danielepais.com\\\/journal\\\/category\\\/web\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/danielepais.com\\\/journal\\\/category\\\/web\\\/wordpress\\\/#listItem\",\"name\":\"Wordpress\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/danielepais.com\\\/journal#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/danielepais.com\\\/journal\\\/category\\\/web\\\/wordpress\\\/#listItem\",\"position\":3,\"name\":\"Wordpress\",\"item\":\"https:\\\/\\\/danielepais.com\\\/journal\\\/category\\\/web\\\/wordpress\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/danielepais.com\\\/journal\\\/3-simple-tweaks-to-shrink-your-wordpress-database-size\\\/#listItem\",\"name\":\"3 simple Tweaks to shrink your WordPress database size\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/danielepais.com\\\/journal\\\/category\\\/web\\\/#listItem\",\"name\":\"Web\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/danielepais.com\\\/journal\\\/3-simple-tweaks-to-shrink-your-wordpress-database-size\\\/#listItem\",\"position\":4,\"name\":\"3 simple Tweaks to shrink your WordPress database size\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/danielepais.com\\\/journal\\\/category\\\/web\\\/wordpress\\\/#listItem\",\"name\":\"Wordpress\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/danielepais.com\\\/journal\\\/#person\",\"name\":\"Daniele Pais\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/danielepais.com\\\/journal\\\/3-simple-tweaks-to-shrink-your-wordpress-database-size\\\/#personImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/86bedf0ab24a6d4a4f32de230cc797ef?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Daniele Pais\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/danielepais.com\\\/journal\\\/author\\\/_-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2--2\\\/#author\",\"url\":\"https:\\\/\\\/danielepais.com\\\/journal\\\/author\\\/_-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2--2\\\/\",\"name\":\"Daniele Pais\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/danielepais.com\\\/journal\\\/3-simple-tweaks-to-shrink-your-wordpress-database-size\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/86bedf0ab24a6d4a4f32de230cc797ef?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Daniele Pais\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/danielepais.com\\\/journal\\\/3-simple-tweaks-to-shrink-your-wordpress-database-size\\\/#webpage\",\"url\":\"https:\\\/\\\/danielepais.com\\\/journal\\\/3-simple-tweaks-to-shrink-your-wordpress-database-size\\\/\",\"name\":\"3 simple Tweaks to shrink your WordPress database size | Phuket Web Design\",\"description\":\"So you have a huge blog and your site pages and posts start taking a bit longer to load and you might ask yourself how could I possibly speed it up?\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/danielepais.com\\\/journal\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/danielepais.com\\\/journal\\\/3-simple-tweaks-to-shrink-your-wordpress-database-size\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/danielepais.com\\\/journal\\\/author\\\/_-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2--2\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/danielepais.com\\\/journal\\\/author\\\/_-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2--2\\\/#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/danielepais.com\\\/journal\\\/wp-content\\\/uploads\\\/2016\\\/12\\\/featured.png\",\"@id\":\"https:\\\/\\\/danielepais.com\\\/journal\\\/3-simple-tweaks-to-shrink-your-wordpress-database-size\\\/#mainImage\",\"width\":566,\"height\":205,\"caption\":\"WordPress Tweaks Featured\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/danielepais.com\\\/journal\\\/3-simple-tweaks-to-shrink-your-wordpress-database-size\\\/#mainImage\"},\"datePublished\":\"2016-12-09T05:19:33+07:00\",\"dateModified\":\"2022-02-03T13:47:53+07:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/danielepais.com\\\/journal\\\/#website\",\"url\":\"https:\\\/\\\/danielepais.com\\\/journal\\\/\",\"name\":\"Phuket Web Design\",\"description\":\"Digital Print\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/danielepais.com\\\/journal\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"3 simple Tweaks to shrink your WordPress database size | Phuket Web Design","description":"So you have a huge blog and your site pages and posts start taking a bit longer to load and you might ask yourself how could I possibly speed it up?","canonical_url":"https:\/\/danielepais.com\/journal\/3-simple-tweaks-to-shrink-your-wordpress-database-size\/","robots":"max-image-preview:large","keywords":"coding,database,performance,speed,tweaks,wordpress,design","webmasterTools":{"google-site-verification":"googleb91c9505ed997b99","msvalidate.01":"AD1C96C338E051848BE08C67378B20CA","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/danielepais.com\/journal\/3-simple-tweaks-to-shrink-your-wordpress-database-size\/#article","name":"3 simple Tweaks to shrink your WordPress database size | Phuket Web Design","headline":"3 simple Tweaks to shrink your WordPress database size","author":{"@id":"https:\/\/danielepais.com\/journal\/author\/_-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2--2\/#author"},"publisher":{"@id":"https:\/\/danielepais.com\/journal\/#person"},"image":{"@type":"ImageObject","url":"https:\/\/danielepais.com\/journal\/wp-content\/uploads\/2016\/12\/featured.png","width":566,"height":205,"caption":"WordPress Tweaks Featured"},"datePublished":"2016-12-09T05:19:33+07:00","dateModified":"2022-02-03T13:47:53+07:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/danielepais.com\/journal\/3-simple-tweaks-to-shrink-your-wordpress-database-size\/#webpage"},"isPartOf":{"@id":"https:\/\/danielepais.com\/journal\/3-simple-tweaks-to-shrink-your-wordpress-database-size\/#webpage"},"articleSection":"Design, Wordpress, coding, database, performance, speed, tweaks, wordpress"},{"@type":"BreadcrumbList","@id":"https:\/\/danielepais.com\/journal\/3-simple-tweaks-to-shrink-your-wordpress-database-size\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/danielepais.com\/journal#listItem","position":1,"name":"Home","item":"https:\/\/danielepais.com\/journal","nextItem":{"@type":"ListItem","@id":"https:\/\/danielepais.com\/journal\/category\/web\/#listItem","name":"Web"}},{"@type":"ListItem","@id":"https:\/\/danielepais.com\/journal\/category\/web\/#listItem","position":2,"name":"Web","item":"https:\/\/danielepais.com\/journal\/category\/web\/","nextItem":{"@type":"ListItem","@id":"https:\/\/danielepais.com\/journal\/category\/web\/wordpress\/#listItem","name":"Wordpress"},"previousItem":{"@type":"ListItem","@id":"https:\/\/danielepais.com\/journal#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/danielepais.com\/journal\/category\/web\/wordpress\/#listItem","position":3,"name":"Wordpress","item":"https:\/\/danielepais.com\/journal\/category\/web\/wordpress\/","nextItem":{"@type":"ListItem","@id":"https:\/\/danielepais.com\/journal\/3-simple-tweaks-to-shrink-your-wordpress-database-size\/#listItem","name":"3 simple Tweaks to shrink your WordPress database size"},"previousItem":{"@type":"ListItem","@id":"https:\/\/danielepais.com\/journal\/category\/web\/#listItem","name":"Web"}},{"@type":"ListItem","@id":"https:\/\/danielepais.com\/journal\/3-simple-tweaks-to-shrink-your-wordpress-database-size\/#listItem","position":4,"name":"3 simple Tweaks to shrink your WordPress database size","previousItem":{"@type":"ListItem","@id":"https:\/\/danielepais.com\/journal\/category\/web\/wordpress\/#listItem","name":"Wordpress"}}]},{"@type":"Person","@id":"https:\/\/danielepais.com\/journal\/#person","name":"Daniele Pais","image":{"@type":"ImageObject","@id":"https:\/\/danielepais.com\/journal\/3-simple-tweaks-to-shrink-your-wordpress-database-size\/#personImage","url":"https:\/\/secure.gravatar.com\/avatar\/86bedf0ab24a6d4a4f32de230cc797ef?s=96&d=mm&r=g","width":96,"height":96,"caption":"Daniele Pais"}},{"@type":"Person","@id":"https:\/\/danielepais.com\/journal\/author\/_-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2--2\/#author","url":"https:\/\/danielepais.com\/journal\/author\/_-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2--2\/","name":"Daniele Pais","image":{"@type":"ImageObject","@id":"https:\/\/danielepais.com\/journal\/3-simple-tweaks-to-shrink-your-wordpress-database-size\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/86bedf0ab24a6d4a4f32de230cc797ef?s=96&d=mm&r=g","width":96,"height":96,"caption":"Daniele Pais"}},{"@type":"WebPage","@id":"https:\/\/danielepais.com\/journal\/3-simple-tweaks-to-shrink-your-wordpress-database-size\/#webpage","url":"https:\/\/danielepais.com\/journal\/3-simple-tweaks-to-shrink-your-wordpress-database-size\/","name":"3 simple Tweaks to shrink your WordPress database size | Phuket Web Design","description":"So you have a huge blog and your site pages and posts start taking a bit longer to load and you might ask yourself how could I possibly speed it up?","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/danielepais.com\/journal\/#website"},"breadcrumb":{"@id":"https:\/\/danielepais.com\/journal\/3-simple-tweaks-to-shrink-your-wordpress-database-size\/#breadcrumblist"},"author":{"@id":"https:\/\/danielepais.com\/journal\/author\/_-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2--2\/#author"},"creator":{"@id":"https:\/\/danielepais.com\/journal\/author\/_-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2--2\/#author"},"image":{"@type":"ImageObject","url":"https:\/\/danielepais.com\/journal\/wp-content\/uploads\/2016\/12\/featured.png","@id":"https:\/\/danielepais.com\/journal\/3-simple-tweaks-to-shrink-your-wordpress-database-size\/#mainImage","width":566,"height":205,"caption":"WordPress Tweaks Featured"},"primaryImageOfPage":{"@id":"https:\/\/danielepais.com\/journal\/3-simple-tweaks-to-shrink-your-wordpress-database-size\/#mainImage"},"datePublished":"2016-12-09T05:19:33+07:00","dateModified":"2022-02-03T13:47:53+07:00"},{"@type":"WebSite","@id":"https:\/\/danielepais.com\/journal\/#website","url":"https:\/\/danielepais.com\/journal\/","name":"Phuket Web Design","description":"Digital Print","inLanguage":"en-US","publisher":{"@id":"https:\/\/danielepais.com\/journal\/#person"}}]},"og:locale":"en_US","og:site_name":"Daniele Pais Blog","og:type":"article","og:title":"3 simple Tweaks to shrink your WordPress database size | Phuket Web Design","og:description":"So you have a huge blog and your site pages and posts start taking a bit longer to load and you might ask yourself how could I possibly speed it up?","og:url":"https:\/\/danielepais.com\/journal\/3-simple-tweaks-to-shrink-your-wordpress-database-size\/","og:image":"https:\/\/danielepais.com\/journal\/wp-content\/uploads\/2016\/12\/featured.png","og:image:secure_url":"https:\/\/danielepais.com\/journal\/wp-content\/uploads\/2016\/12\/featured.png","og:image:width":566,"og:image:height":205,"article:published_time":"2016-12-09T05:19:33+00:00","article:modified_time":"2022-02-03T06:47:53+00:00","twitter:card":"summary","twitter:site":"@daniele_pais","twitter:title":"3 simple Tweaks to shrink your WordPress database size | Phuket Web Design","twitter:description":"So you have a huge blog and your site pages and posts start taking a bit longer to load and you might ask yourself how could I possibly speed it up?","twitter:image":"https:\/\/danielepais.com\/journal\/wp-content\/uploads\/2017\/10\/daniele-pais-digital-design.png"},"aioseo_meta_data":{"post_id":"327","title":"3 simple Tweaks to shrink your WordPress database size | #site_title","description":"So you have a huge blog and your site pages and posts start taking a bit longer to load and you might ask yourself how could I possibly speed it up?","keywords":[{"label":"coding","value":"coding"},{"label":"database","value":"database"},{"label":"performance","value":"performance"},{"label":"speed","value":"speed"},{"label":"tweaks","value":"tweaks"},{"label":"wordpress","value":"wordpress"}],"keyphrases":{"focus":[],"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":[],"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[],"defaultGraph":"Article","defaultPostTypeGraph":""},"schema_type":"default","schema_type_options":"{\"article\":{\"articleType\":\"BlogPosting\"},\"course\":{\"name\":\"\",\"description\":\"\",\"provider\":\"\"},\"faq\":{\"pages\":[]},\"product\":{\"reviews\":[]},\"recipe\":{\"ingredients\":[],\"instructions\":[],\"keywords\":[]},\"software\":{\"reviews\":[],\"operatingSystems\":[]},\"webPage\":{\"webPageType\":\"WebPage\"}}","pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","location":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"created":"2020-12-28 02:12:49","updated":"2025-06-11 18:45:45","ai":null,"seo_analyzer_scan_date":null},"_links":{"self":[{"href":"https:\/\/danielepais.com\/journal\/wp-json\/wp\/v2\/posts\/327"}],"collection":[{"href":"https:\/\/danielepais.com\/journal\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/danielepais.com\/journal\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/danielepais.com\/journal\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/danielepais.com\/journal\/wp-json\/wp\/v2\/comments?post=327"}],"version-history":[{"count":0,"href":"https:\/\/danielepais.com\/journal\/wp-json\/wp\/v2\/posts\/327\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/danielepais.com\/journal\/wp-json\/wp\/v2\/media\/338"}],"wp:attachment":[{"href":"https:\/\/danielepais.com\/journal\/wp-json\/wp\/v2\/media?parent=327"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/danielepais.com\/journal\/wp-json\/wp\/v2\/categories?post=327"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/danielepais.com\/journal\/wp-json\/wp\/v2\/tags?post=327"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}