{"id":59294,"date":"2017-01-11T11:48:44","date_gmt":"2017-01-11T11:48:44","guid":{"rendered":"https:\/\/silicondales.com\/?p=59294"},"modified":"2019-04-16T11:34:02","modified_gmt":"2019-04-16T10:34:02","slug":"big-wordpress-problem-slow-wp-admin-uncached-pageloads-slow","status":"publish","type":"post","link":"https:\/\/silicondales.com\/tutorials\/wordpress\/big-wordpress-problem-slow-wp-admin-uncached-pageloads-slow\/","title":{"rendered":"Big WordPress Problem &#8211; Slow WP Admin \/ Uncached Pageloads Slow"},"content":{"rendered":"<p>Some problems are first world problems. Other problems are big WordPress problems.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_65 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-662da556a5898\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"ez-toc-cssicon\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #0a0a0a;color:#0a0a0a\" 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: #0a0a0a;color:#0a0a0a\" 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-662da556a5898\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/silicondales.com\/tutorials\/wordpress\/big-wordpress-problem-slow-wp-admin-uncached-pageloads-slow\/#Slow_WordPress_Admin_Slow_uncached_pageloads\" title=\"Slow WordPress Admin? Slow uncached pageloads?\">Slow WordPress Admin? Slow uncached pageloads?<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/silicondales.com\/tutorials\/wordpress\/big-wordpress-problem-slow-wp-admin-uncached-pageloads-slow\/#Hint_%E2%80%93_get_better_hosting\" title=\"Hint &#8211; get better hosting\">Hint &#8211; get better hosting<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/silicondales.com\/tutorials\/wordpress\/big-wordpress-problem-slow-wp-admin-uncached-pageloads-slow\/#Method_1_%E2%80%93_Reduce_WP_Options_database_size\" title=\"Method 1 &#8211; Reduce WP_Options database size\">Method 1 &#8211; Reduce WP_Options database size<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/silicondales.com\/tutorials\/wordpress\/big-wordpress-problem-slow-wp-admin-uncached-pageloads-slow\/#Method_2_%E2%80%93_Add_an_Index_to_wp_options_database_on_autoload\" title=\"Method 2 &#8211; Add an Index to wp_options database on autoload\">Method 2 &#8211; Add an Index to wp_options database on autoload<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/silicondales.com\/tutorials\/wordpress\/big-wordpress-problem-slow-wp-admin-uncached-pageloads-slow\/#Method_3_%E2%80%93_Big_Postmeta_%E2%80%93_make_wp_postmeta_varchar191\" title=\"Method 3 &#8211; Big Postmeta &#8211; make wp_postmeta varchar(191)\">Method 3 &#8211; Big Postmeta &#8211; make wp_postmeta varchar(191)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/silicondales.com\/tutorials\/wordpress\/big-wordpress-problem-slow-wp-admin-uncached-pageloads-slow\/#Other_things_which_will_help\" title=\"Other things which will help\">Other things which will help<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Slow_WordPress_Admin_Slow_uncached_pageloads\"><\/span>Slow WordPress Admin? Slow uncached pageloads?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>We deal with some big WordPress customers, and often their sites can become slow. There&#8217;s sometimes a myth floating around that &#8220;WordPress doesn&#8217;t scale&#8221; or, more specifically, that &#8220;WooCommerce doesn&#8217;t scale&#8221; but there&#8217;s a reason I call this a myth&#8230; because it isn&#8217;t necessarily true.<\/p>\n<p>There are, however, some things that big WordPress, and in particular, big WooCommerce, doesn&#8217;t do well without some minor customisations.<\/p>\n<p>Now, before I get into the meat and bones of what I&#8217;m talking about (which is essentially 2-3 tactics I always start with to attempt to speed up a slow big WordPress\/ WooCommerce website) I&#8217;m going to say one thing: slowness is almost always hosting related.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Hint_%E2%80%93_get_better_hosting\"><\/span>Hint &#8211; get better hosting<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>If you are trying to host a 50,000 product WooCommerce store on $2 GoDaddy hosting, you are going to have a bad time. So, advice number one: don&#8217;t do that. Get the biggest and best hosting you can afford. Seriously. If you cannot afford $50 a month for a reasonable slice, then you will probably struggle to maintain the rest of the necessary infrastructure to run a 50,000 product store.<\/p>\n<p>That might feel like an arrogant statement, but it is a broadly brushed fact, based on a lot of experience. Your hosting is not the place to shave costs, if you are a\u00a0<strong>web based busines<\/strong><strong>s<\/strong> like an e-commerce website!<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Method_1_%E2%80%93_Reduce_WP_Options_database_size\"><\/span>Method 1 &#8211; Reduce WP_Options database size<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Having a large WP_options table in your database is often what slows down admin loading times. Getting someone who knows what they are doing to remove unused (aka orphaned) options from your wp_options db table can have a significant performance increase. If you&#8217;re still using a plugin which has peppered options in here, consider un-using it!<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Method_2_%E2%80%93_Add_an_Index_to_wp_options_database_on_autoload\"><\/span>Method 2 &#8211; Add an Index to wp_options database on autoload<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>More specifically, WordPress looks for &#8220;autoload&#8221; options in admin. If admin is slow, then sometimes speed improvements can be made by adding an index to the wp_options table.<\/p>\n<p>There&#8217;s a full thread on this at WordPress trac <a href=\"https:\/\/core.trac.wordpress.org\/ticket\/24044\" target=\"_blank\" rel=\"noopener\">here<\/a>.<\/p>\n<p>To do the TLDR, the following SQL command on your WP MySQL db can speed things up (backup first, backup often, backup!!):<\/p>\n<p><code>CREATE INDEX autoload ON wp_options(autoload, option_name);<\/code><\/p>\n<p>This needs to be tested in your setup to see if improvements indeed occur.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Method_3_%E2%80%93_Big_Postmeta_%E2%80%93_make_wp_postmeta_varchar191\"><\/span>Method 3 &#8211; Big Postmeta &#8211; make wp_postmeta varchar(191)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>This is another one which is more WooCommerce specific, but also will apply to sites with lots of post meta (custom fields) so maybe if you have a big site that uses ACF (Advanced Custom Fields) or similar, you will want to try this in your staging site to speed up admin and logged in user accesses to the site.<\/p>\n<p>WordPress by default has postmeta stored in a larger amount than is always necessary.<\/p>\n<p>Running this command on the WordPress MySQL db can make the admin load faster on sites with lots of post meta:<\/p>\n<p><code>ALTER TABLE wp_postmeta MODIFY meta_key varchar(191);<\/code><\/p>\n<p>You definitely must <strong>check if you have meta_key that is longer than 190 chars before doing this<\/strong> (and fix those if you do &#8211; although why?! Why is it that long?! Please somebody tell me why!!!) and also backup your db first &#8211; or at least this table.<\/p>\n<p>The thread on this one is found <a href=\"https:\/\/core.trac.wordpress.org\/ticket\/33885\" target=\"_blank\" rel=\"noopener\">here<\/a>.<\/p>\n<p>The above queries can often speed up WordPress performance significantly, allowing it to scale successfully to xxx,000 posts, products or custom post types.<\/p>\n<p>There are further context specific customisation which may also help. For those, please contact us.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Other_things_which_will_help\"><\/span>Other things which will help<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>Upgrade PHP to version 7.2, 7.1 or 7.0 &#8211; if you can<\/li>\n<li>Migrate to a <a href=\"https:\/\/silicondales.com\/tutorials\/woocommerce\/hosting\/\">quality WooCommerce host<\/a><\/li>\n<li>Audit your plugins &#8211; remove any which you do not <strong>need<\/strong><\/li>\n<li>Clean out anything old plugins and themes left behind<\/li>\n<li><a href=\"https:\/\/silicondales.com\/woocommerce\/speed-optimization\/\">Book Silicon Dales for a full WooCommerce optimization<\/a><\/li>\n<\/ul>\n<p>There will be other tactics which will help, but your exact mileage will vary based on your setup. Please leave a comment if this worked or doesn&#8217;t work for you, below.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Some problems are first world problems. Other problems are big WordPress problems. Slow WordPress Admin? Slow uncached pageloads? We deal with some big WordPress customers, and often their sites can become slow. There&#8217;s sometimes a myth floating around that &#8220;WordPress doesn&#8217;t scale&#8221; or, more specifically, that &#8220;WooCommerce doesn&#8217;t scale&#8221; but there&#8217;s a reason I call &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"Big WordPress Problem &#8211; Slow WP Admin \/ Uncached Pageloads Slow\" class=\"read-more button\" href=\"https:\/\/silicondales.com\/tutorials\/wordpress\/big-wordpress-problem-slow-wp-admin-uncached-pageloads-slow\/#more-59294\" aria-label=\"Read more about Big WordPress Problem &#8211; Slow WP Admin \/ Uncached Pageloads Slow\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":62216,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[10,2327],"tags":[4330,1133,2326,2325,4829],"acf":[],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/silicondales.com\/wp-json\/wp\/v2\/posts\/59294"}],"collection":[{"href":"https:\/\/silicondales.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/silicondales.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/silicondales.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/silicondales.com\/wp-json\/wp\/v2\/comments?post=59294"}],"version-history":[{"count":0,"href":"https:\/\/silicondales.com\/wp-json\/wp\/v2\/posts\/59294\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/silicondales.com\/wp-json\/wp\/v2\/media\/62216"}],"wp:attachment":[{"href":"https:\/\/silicondales.com\/wp-json\/wp\/v2\/media?parent=59294"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/silicondales.com\/wp-json\/wp\/v2\/categories?post=59294"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/silicondales.com\/wp-json\/wp\/v2\/tags?post=59294"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}