{"id":1082113,"date":"2016-02-25T10:41:31","date_gmt":"2016-02-25T18:41:31","guid":{"rendered":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-issues-causing-very-slow-loading-of-site-on-front-and-back-end\/"},"modified":"2016-03-29T09:35:10","modified_gmt":"2016-03-29T16:35:10","slug":"database-issues-causing-very-slow-loading-of-site-on-front-and-back-end","status":"closed","type":"topic","link":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-issues-causing-very-slow-loading-of-site-on-front-and-back-end\/","title":{"rendered":"Database issues causing very slow loading of site on front and back end"},"content":{"rendered":"<p>We have noticed since our site has been up for a while that it has been getting slower and slower (on both the front end for users and the wordpress admin side). Our host has bumped up our hosting speed but it didn&#8217;t make any difference. On further inspection of the database, it seems that your plugin is using more cpu that I would expect so something might be awry.  A quick look shows that there may be something going on with the wp_options table \u2014 it\u2019s got around 70,000 entries and is over 2 GB in size. We think this is causing it to be very slow when doing anything at all with the data in it.  It seems to be a lot of tribe-related messages with transient timeouts and such. <\/p>\n<p>Can you help us figure out why the plugin isn&#8217;t going through and deleting unnecessary files?<\/p>\n","protected":false},"template":"","class_list":["post-1082113","topic","type-topic","status-closed","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Database issues causing very slow loading of site on front and back end -<\/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:\/\/theeventscalendar.com\/support\/forums\/topic\/database-issues-causing-very-slow-loading-of-site-on-front-and-back-end\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Database issues causing very slow loading of site on front and back end -\" \/>\n<meta property=\"og:description\" content=\"We have noticed since our site has been up for a while that it has been getting slower and slower (on both the front end for users and the wordpress admin side). Our host has bumped up our hosting speed but it didn&#8217;t make any difference. On further inspection of the database, it seems that [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-issues-causing-very-slow-loading-of-site-on-front-and-back-end\/\" \/>\n<meta property=\"article:modified_time\" content=\"2016-03-29T16:35:10+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-issues-causing-very-slow-loading-of-site-on-front-and-back-end\/\",\"url\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-issues-causing-very-slow-loading-of-site-on-front-and-back-end\/\",\"name\":\"Database issues causing very slow loading of site on front and back end -\",\"isPartOf\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\"},\"datePublished\":\"2016-02-25T18:41:31+00:00\",\"dateModified\":\"2016-03-29T16:35:10+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-issues-causing-very-slow-loading-of-site-on-front-and-back-end\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-issues-causing-very-slow-loading-of-site-on-front-and-back-end\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-issues-causing-very-slow-loading-of-site-on-front-and-back-end\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/theeventscalendar.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Topics\",\"item\":\"https:\/\/theeventscalendar.com\/support\/topics\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Calendar Products\",\"item\":\"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Events Calendar PRO\",\"item\":\"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/events-calendar-pro\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Database issues causing very slow loading of site on front and back end\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\",\"url\":\"https:\/\/theeventscalendar.com\/support\/\",\"name\":\"\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/theeventscalendar.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Database issues causing very slow loading of site on front and back end -","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:\/\/theeventscalendar.com\/support\/forums\/topic\/database-issues-causing-very-slow-loading-of-site-on-front-and-back-end\/","og_locale":"en_US","og_type":"article","og_title":"Database issues causing very slow loading of site on front and back end -","og_description":"We have noticed since our site has been up for a while that it has been getting slower and slower (on both the front end for users and the wordpress admin side). Our host has bumped up our hosting speed but it didn&#8217;t make any difference. On further inspection of the database, it seems that [&hellip;]","og_url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-issues-causing-very-slow-loading-of-site-on-front-and-back-end\/","article_modified_time":"2016-03-29T16:35:10+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-issues-causing-very-slow-loading-of-site-on-front-and-back-end\/","url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-issues-causing-very-slow-loading-of-site-on-front-and-back-end\/","name":"Database issues causing very slow loading of site on front and back end -","isPartOf":{"@id":"https:\/\/theeventscalendar.com\/support\/#website"},"datePublished":"2016-02-25T18:41:31+00:00","dateModified":"2016-03-29T16:35:10+00:00","breadcrumb":{"@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-issues-causing-very-slow-loading-of-site-on-front-and-back-end\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-issues-causing-very-slow-loading-of-site-on-front-and-back-end\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-issues-causing-very-slow-loading-of-site-on-front-and-back-end\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/theeventscalendar.com\/support\/"},{"@type":"ListItem","position":2,"name":"Topics","item":"https:\/\/theeventscalendar.com\/support\/topics\/"},{"@type":"ListItem","position":3,"name":"Calendar Products","item":"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/"},{"@type":"ListItem","position":4,"name":"Events Calendar PRO","item":"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/events-calendar-pro\/"},{"@type":"ListItem","position":5,"name":"Database issues causing very slow loading of site on front and back end"}]},{"@type":"WebSite","@id":"https:\/\/theeventscalendar.com\/support\/#website","url":"https:\/\/theeventscalendar.com\/support\/","name":"","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/theeventscalendar.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1082113","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":1,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1082113\/revisions"}],"predecessor-version":[{"id":1082554,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1082113\/revisions\/1082554"}],"wp:attachment":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/media?parent=1082113"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}