{"id":1268728,"date":"2017-04-12T02:57:09","date_gmt":"2017-04-12T09:57:09","guid":{"rendered":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-problems\/"},"modified":"2017-04-13T20:55:24","modified_gmt":"2017-04-14T03:55:24","slug":"database-problems","status":"closed","type":"topic","link":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-problems\/","title":{"rendered":"Database Problems"},"content":{"rendered":"<p>Hi there,<\/p>\n<p>currently, we note very high database load for queries from the Events Calendar plugin. We have about 5000 events within 15000 posts. <\/p>\n<p>This query needs up to 25 seconds (!) for the first call, it&#8217;s fast for the second call as it&#8217;s in the query cache after 1st call.<\/p>\n<pre><code>\r\nSELECT COUNT( DISTINCT( ID ) )\r\n                        FROM   wp_posts\r\n                        WHERE  wp_posts.post_type = &#039;tribe_events&#039;\r\n                        AND    wp_posts.post_status &lt;&gt; &#039;auto-draft&#039;\r\n                        AND    ID NOT IN (\r\n                                   -- Find those posts that already have timezone meta data\r\n                                   SELECT DISTINCT ( post_id )\r\n                                   FROM   wp_postmeta\r\n                                   WHERE  meta_key = &#039;_EventTimezone&#039;\r\n                               )\r\n                        LIMIT 1;\r\n<\/code><\/pre>\n<p>Can you please think over replacing subselects with joins? Subselects like this are very expensive concerning performance. <\/p>\n<p>Cheers Alex<\/p>\n","protected":false},"template":"","class_list":["post-1268728","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 Problems -<\/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-problems\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Database Problems -\" \/>\n<meta property=\"og:description\" content=\"Hi there, currently, we note very high database load for queries from the Events Calendar plugin. We have about 5000 events within 15000 posts. This query needs up to 25 seconds (!) for the first call, it&#8217;s fast for the second call as it&#8217;s in the query cache after 1st call. SELECT COUNT( DISTINCT( ID [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-problems\/\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-14T03:55:24+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-problems\/\",\"url\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-problems\/\",\"name\":\"Database Problems -\",\"isPartOf\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\"},\"datePublished\":\"2017-04-12T09:57:09+00:00\",\"dateModified\":\"2017-04-14T03:55:24+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-problems\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-problems\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-problems\/#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 Problems\"}]},{\"@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 Problems -","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-problems\/","og_locale":"en_US","og_type":"article","og_title":"Database Problems -","og_description":"Hi there, currently, we note very high database load for queries from the Events Calendar plugin. We have about 5000 events within 15000 posts. This query needs up to 25 seconds (!) for the first call, it&#8217;s fast for the second call as it&#8217;s in the query cache after 1st call. SELECT COUNT( DISTINCT( ID [&hellip;]","og_url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-problems\/","article_modified_time":"2017-04-14T03:55:24+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-problems\/","url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-problems\/","name":"Database Problems -","isPartOf":{"@id":"https:\/\/theeventscalendar.com\/support\/#website"},"datePublished":"2017-04-12T09:57:09+00:00","dateModified":"2017-04-14T03:55:24+00:00","breadcrumb":{"@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-problems\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-problems\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-problems\/#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 Problems"}]},{"@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\/1268728","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\/1268728\/revisions"}],"predecessor-version":[{"id":1269818,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1268728\/revisions\/1269818"}],"wp:attachment":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/media?parent=1268728"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}