{"id":986149,"date":"2015-07-13T22:08:33","date_gmt":"2015-07-14T05:08:33","guid":{"rendered":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/my-site-is-going-really-slow-2\/"},"modified":"2015-08-07T07:05:04","modified_gmt":"2015-08-07T14:05:04","slug":"my-site-is-going-really-slow-2","status":"closed","type":"topic","link":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/my-site-is-going-really-slow-2\/","title":{"rendered":"My site is going really slow 2"},"content":{"rendered":"

Hi<\/p>\n

I’ve moved to WPEngine now, and did all the needed cache, but the site is still going slow. Below are the database query from the event calendar that went for more than 0.05 seconds.<\/p>\n

SELECT DISTINCT wp_posts.ID, MIN(wp_postmeta.meta_value) as EventStartDate, tribe_event_end_date.meta_value as EventEndDate
\nFROM wp_posts
\nINNER JOIN wp_postmeta
\nON ( wp_posts.ID = wp_postmeta.post_id )
\nLEFT JOIN wp_postmeta as tribe_event_end_date
\nON ( wp_posts.ID = tribe_event_end_date.post_id
\nAND tribe_event_end_date.meta_key = ‘_EventEndDate’ )
\nWHERE 1=1
\nAND ( wp_postmeta.meta_key = ‘_EventStartDate’ )
\nAND wp_posts.post_type = ‘tribe_events’
\nAND (wp_posts.post_status = ‘publish’
\nOR wp_posts.post_status = ‘closed’
\nOR wp_posts.post_status = ‘private’
\nOR wp_posts.post_status = ‘hidden’)
\nAND ((wp_postmeta.meta_value >= ‘2015-06-29 00:00:00’
\nAND wp_postmeta.meta_value <= ‘2015-08-02 00:00:00’)
\nOR (tribe_event_end_date.meta_value >= ‘2015-06-29 00:00:00’
\nAND wp_postmeta.meta_value <= ‘2015-08-02 00:00:00’ )
\nOR (wp_postmeta.meta_value < ‘2015-06-29 00:00:00’
\nAND tribe_event_end_date.meta_value >= ‘2015-08-02 00:00:00’ ))
\nGROUP BY IF( wp_posts.post_parent = 0, wp_posts.ID, wp_posts.post_parent )
\nORDER BY EventStartDate ASC<\/p>\n

——————————————-<\/p>\n

SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*, MIN(wp_postmeta.meta_value) as EventStartDate, tribe_event_end_date.meta_value as EventEndDate
\nFROM wp_posts
\nINNER JOIN wp_postmeta
\nON ( wp_posts.ID = wp_postmeta.post_id )
\nLEFT JOIN wp_postmeta as tribe_event_end_date
\nON ( wp_posts.ID = tribe_event_end_date.post_id
\nAND tribe_event_end_date.meta_key = ‘_EventEndDate’ )
\nWHERE 1=1
\nAND ( wp_postmeta.meta_key = ‘_EventStartDate’ )
\nAND wp_posts.post_type = ‘tribe_events’
\nAND ((wp_posts.post_status = ‘publish’
\nOR wp_posts.post_status = ‘private’))
\nAND ((wp_postmeta.meta_value >= ‘2015-07-14 12:00:41’
\nAND wp_postmeta.meta_value <= ‘2015-07-31 23:59:59’)
\nOR (tribe_event_end_date.meta_value >= ‘2015-07-14 12:00:41’
\nAND wp_postmeta.meta_value <= ‘2015-07-31 23:59:59’ )
\nOR (wp_postmeta.meta_value < ‘2015-07-14 12:00:41’
\nAND tribe_event_end_date.meta_value >= ‘2015-07-31 23:59:59’ ))
\nGROUP BY IF( wp_posts.post_parent = 0, wp_posts.ID, wp_posts.post_parent )
\nORDER BY EventStartDate ASC
\nLIMIT 0, 5<\/p>\n","protected":false},"template":"","class_list":["post-986149","topic","type-topic","status-closed","hentry"],"yoast_head":"\nMy site is going really slow 2 -<\/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\/my-site-is-going-really-slow-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"My site is going really slow 2 -\" \/>\n<meta property=\"og:description\" content=\"Hi I’ve moved to WPEngine now, and did all the needed cache, but the site is still going slow. Below are the database query from the event calendar that went for more than 0.05 seconds. SELECT DISTINCT wp_posts.ID, MIN(wp_postmeta.meta_value) as EventStartDate, tribe_event_end_date.meta_value as EventEndDate FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/my-site-is-going-really-slow-2\/\" \/>\n<meta property=\"article:modified_time\" content=\"2015-08-07T14:05:04+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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/my-site-is-going-really-slow-2\/\",\"url\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/my-site-is-going-really-slow-2\/\",\"name\":\"My site is going really slow 2 -\",\"isPartOf\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\"},\"datePublished\":\"2015-07-14T05:08:33+00:00\",\"dateModified\":\"2015-08-07T14:05:04+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/my-site-is-going-really-slow-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/my-site-is-going-really-slow-2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/my-site-is-going-really-slow-2\/#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\":\"My site is going really slow 2\"}]},{\"@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":"My site is going really slow 2 -","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\/my-site-is-going-really-slow-2\/","og_locale":"en_US","og_type":"article","og_title":"My site is going really slow 2 -","og_description":"Hi I’ve moved to WPEngine now, and did all the needed cache, but the site is still going slow. Below are the database query from the event calendar that went for more than 0.05 seconds. SELECT DISTINCT wp_posts.ID, MIN(wp_postmeta.meta_value) as EventStartDate, tribe_event_end_date.meta_value as EventEndDate FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) […]","og_url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/my-site-is-going-really-slow-2\/","article_modified_time":"2015-08-07T14:05:04+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/my-site-is-going-really-slow-2\/","url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/my-site-is-going-really-slow-2\/","name":"My site is going really slow 2 -","isPartOf":{"@id":"https:\/\/theeventscalendar.com\/support\/#website"},"datePublished":"2015-07-14T05:08:33+00:00","dateModified":"2015-08-07T14:05:04+00:00","breadcrumb":{"@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/my-site-is-going-really-slow-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/theeventscalendar.com\/support\/forums\/topic\/my-site-is-going-really-slow-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/my-site-is-going-really-slow-2\/#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":"My site is going really slow 2"}]},{"@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\/986149","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\/986149\/revisions"}],"predecessor-version":[{"id":986304,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/986149\/revisions\/986304"}],"wp:attachment":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/media?parent=986149"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}