{"id":1111620,"date":"2016-05-06T11:33:15","date_gmt":"2016-05-06T18:33:15","guid":{"rendered":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/query-is-too-long-for-organizers-info-and-venue-info-methods\/"},"modified":"2016-05-21T09:35:05","modified_gmt":"2016-05-21T16:35:05","slug":"query-is-too-long-for-organizers-info-and-venue-info-methods","status":"closed","type":"topic","link":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/query-is-too-long-for-organizers-info-and-venue-info-methods\/","title":{"rendered":"Query is too long for organizers info and venue info methods"},"content":{"rendered":"<p>Hey guys,<\/p>\n<p>We&#8217;re seeing some errors in our clients logs (hosted on WP Engine) where the query is too long: (KILLED QUERY (19054 characters long generated in &lt;path&gt;\/plugins\/the-events-calendar\/src\/Tribe\/Main.php:3536) * also same error for line 3444. We see this when loading any of the event pages in Admin and it takes a good while to load any page. So looks like the queries in get_venue_info and get_organizer_info are causing this.<\/p>\n<p>Looking at our database, 3,660 venues with 1,215 of those as pending. For organizers, we have 3,235 with 1,100 as pending. Are we hitting a limitation here with the amount of data? Or is there any kind of workaround to narrow that query down or any settings we can use to keep the query from getting killed by WP Engine? Just trying to gather some ideas on what steps we can take to remedy this one.<\/p>\n<p>Thanks guys for all your help!<\/p>\n<p>Casey<\/p>\n","protected":false},"template":"","class_list":["post-1111620","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>Query is too long for organizers info and venue info methods -<\/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\/query-is-too-long-for-organizers-info-and-venue-info-methods\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Query is too long for organizers info and venue info methods -\" \/>\n<meta property=\"og:description\" content=\"Hey guys, We&#8217;re seeing some errors in our clients logs (hosted on WP Engine) where the query is too long: (KILLED QUERY (19054 characters long generated in &lt;path&gt;\/plugins\/the-events-calendar\/src\/Tribe\/Main.php:3536) * also same error for line 3444. We see this when loading any of the event pages in Admin and it takes a good while to load [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/query-is-too-long-for-organizers-info-and-venue-info-methods\/\" \/>\n<meta property=\"article:modified_time\" content=\"2016-05-21T16:35:05+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\/query-is-too-long-for-organizers-info-and-venue-info-methods\/\",\"url\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/query-is-too-long-for-organizers-info-and-venue-info-methods\/\",\"name\":\"Query is too long for organizers info and venue info methods -\",\"isPartOf\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\"},\"datePublished\":\"2016-05-06T18:33:15+00:00\",\"dateModified\":\"2016-05-21T16:35:05+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/query-is-too-long-for-organizers-info-and-venue-info-methods\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/query-is-too-long-for-organizers-info-and-venue-info-methods\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/query-is-too-long-for-organizers-info-and-venue-info-methods\/#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\":\"Community Events\",\"item\":\"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/community-events\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Query is too long for organizers info and venue info methods\"}]},{\"@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":"Query is too long for organizers info and venue info methods -","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\/query-is-too-long-for-organizers-info-and-venue-info-methods\/","og_locale":"en_US","og_type":"article","og_title":"Query is too long for organizers info and venue info methods -","og_description":"Hey guys, We&#8217;re seeing some errors in our clients logs (hosted on WP Engine) where the query is too long: (KILLED QUERY (19054 characters long generated in &lt;path&gt;\/plugins\/the-events-calendar\/src\/Tribe\/Main.php:3536) * also same error for line 3444. We see this when loading any of the event pages in Admin and it takes a good while to load [&hellip;]","og_url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/query-is-too-long-for-organizers-info-and-venue-info-methods\/","article_modified_time":"2016-05-21T16:35:05+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\/query-is-too-long-for-organizers-info-and-venue-info-methods\/","url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/query-is-too-long-for-organizers-info-and-venue-info-methods\/","name":"Query is too long for organizers info and venue info methods -","isPartOf":{"@id":"https:\/\/theeventscalendar.com\/support\/#website"},"datePublished":"2016-05-06T18:33:15+00:00","dateModified":"2016-05-21T16:35:05+00:00","breadcrumb":{"@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/query-is-too-long-for-organizers-info-and-venue-info-methods\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/theeventscalendar.com\/support\/forums\/topic\/query-is-too-long-for-organizers-info-and-venue-info-methods\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/query-is-too-long-for-organizers-info-and-venue-info-methods\/#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":"Community Events","item":"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/community-events\/"},{"@type":"ListItem","position":5,"name":"Query is too long for organizers info and venue info methods"}]},{"@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\/1111620","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\/1111620\/revisions"}],"predecessor-version":[{"id":1111626,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1111620\/revisions\/1111626"}],"wp:attachment":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/media?parent=1111620"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}