{"id":782363,"date":"2014-10-02T01:22:04","date_gmt":"2014-10-02T08:22:04","guid":{"rendered":"http:\/\/tri.be\/support\/forums\/topic\/enormous-perfomance-problems\/"},"modified":"2014-10-21T09:30:42","modified_gmt":"2014-10-21T16:30:42","slug":"enormous-perfomance-problems","status":"closed","type":"topic","link":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/enormous-perfomance-problems\/","title":{"rendered":"Enormous Perfomance Problems"},"content":{"rendered":"<p>Hi ..<br \/>\nwe have enormous perfomance Problems with your Plugin.<br \/>\nOur whole server crashes !!!!!! So we have to deactivate the plugin.<br \/>\nWe have up to 255 Events and its gettin more (round about 1000 Events).<br \/>\nWe tried the update 3.7. Same problems.<br \/>\nOur Server-Administrator send me me the repsonsible SQL-Query:<\/p>\n<p>SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*, wp_postmeta.meta_value as EventStartDate, tribe_event_end_date.meta_value as EventEndDate FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_relationships AS tt1 ON (wp_posts.ID = tt1.object_id) INNER JOIN wp_term_relationships AS tt2 ON (wp_posts.ID = tt2.object_id) INNER JOIN wp_term_relationships AS tt3 ON (wp_posts.ID = tt3.object_id) INNER JOIN wp_term_relationships AS tt4 ON (wp_posts.ID = tt4.object_id) INNER JOIN wp_term_relationships AS tt5 ON (wp_posts.ID = tt5.object_id) INNER JOIN wp_term_relationships AS tt6 ON (wp_posts.ID = tt6.object_id) INNER JOIN wp_term_relationships AS tt7 ON (wp_posts.ID = tt7.object_id) INNER JOIN wp_term_relationships AS tt8 ON (wp_posts.ID = tt8.object_id) INNER JOIN wp_term_relationships AS tt9 ON (wp_posts.ID = tt9.object_id) INNER JOIN wp_term_relationships AS tt10 ON (wp_posts.ID = tt10.object_id) INNER JOIN wp_term_relationships AS tt11 ON (wp_posts.ID = tt11.object_id) INNER JOIN wp_term_relationships AS tt12 ON (wp_posts.ID = tt12.object_id) INNER JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id) LEFT JOIN wp_postmeta as tribe_event_end_date ON ( wp_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = &#8216;_EventEndDate&#8217; ) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (147) OR tt1.term_taxonomy_id IN (148) OR tt2.term_taxonomy_id IN (146) OR tt3.term_taxonomy_id IN (132) OR tt4.term_taxonomy_id IN (143) OR tt5.term_taxonomy_id IN (142) OR tt6.term_taxonomy_id IN (134) OR tt7.term_taxonomy_id IN (133) OR tt8.term_taxonomy_id IN (131) OR tt9.term_taxonomy_id IN (141) OR tt10.term_taxonomy_id IN (145) OR tt11.term_taxonomy_id IN (144) OR tt12.term_taxonomy_id IN (149) ) AND wp_posts.post_type = &#8216;tribe_events&#8217; AND ((wp_posts.post_status = &#8216;publish&#8217;)) AND (wp_postmeta.meta_key = &#8216;_EventStartDate&#8217; ) AND (wp_postmeta.meta_value &gt;= &#8216;2014-09-15 10:17:09&#8217; OR (wp_postmeta.meta_value &lt;= &#8216;2014-09-15 10:17:09&#8217; AND tribe_event_end_date.meta_value &gt;= &#8216;2014-09-15 10:17:09&#8217; )) ORDER BY DATE(wp_postmeta.meta_value) ASC, TIME(wp_postmeta.meta_value) ASC LIMIT 0, 3;<br \/>\nThe SQL-Query crashes our SYSTEM and we have stop the process manually.<br \/>\nOur developer told me, that it could be the problem with Categories:<br \/>\nevents-calendar-pro.php : 188<br \/>\nadd_filter( &#8216;tribe_events_query_posts_joins&#8217;, array($this, &#8216;posts_join&#8217;));<\/p>\n<p>We set up our developer version on blank.woodlandevents.eu and there are only 44 Events. There&#8217;s no problem.<br \/>\nOn the LIVE-System www.woodlandevents.eu with 250 Events there&#8217;s have no chance.<br \/>\nPlease make a update of your query or anything else.<br \/>\nOur client is very pissed at the moment.<br \/>\nThanks for your help.<br \/>\nBest regards<\/p>\n","protected":false},"template":"","class_list":["post-782363","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>Enormous Perfomance 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\/enormous-perfomance-problems\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Enormous Perfomance Problems  -\" \/>\n<meta property=\"og:description\" content=\"Hi .. we have enormous perfomance Problems with your Plugin. Our whole server crashes !!!!!! So we have to deactivate the plugin. We have up to 255 Events and its gettin more (round about 1000 Events). We tried the update 3.7. Same problems. Our Server-Administrator send me me the repsonsible SQL-Query: SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*, [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/enormous-perfomance-problems\/\" \/>\n<meta property=\"article:modified_time\" content=\"2014-10-21T16:30:42+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=\"3 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\/enormous-perfomance-problems\/\",\"url\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/enormous-perfomance-problems\/\",\"name\":\"Enormous Perfomance Problems -\",\"isPartOf\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\"},\"datePublished\":\"2014-10-02T08:22:04+00:00\",\"dateModified\":\"2014-10-21T16:30:42+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/enormous-perfomance-problems\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/enormous-perfomance-problems\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/enormous-perfomance-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\":\"Enormous Perfomance 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":"Enormous Perfomance 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\/enormous-perfomance-problems\/","og_locale":"en_US","og_type":"article","og_title":"Enormous Perfomance Problems  -","og_description":"Hi .. we have enormous perfomance Problems with your Plugin. Our whole server crashes !!!!!! So we have to deactivate the plugin. We have up to 255 Events and its gettin more (round about 1000 Events). We tried the update 3.7. Same problems. Our Server-Administrator send me me the repsonsible SQL-Query: SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*, [&hellip;]","og_url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/enormous-perfomance-problems\/","article_modified_time":"2014-10-21T16:30:42+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/enormous-perfomance-problems\/","url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/enormous-perfomance-problems\/","name":"Enormous Perfomance Problems -","isPartOf":{"@id":"https:\/\/theeventscalendar.com\/support\/#website"},"datePublished":"2014-10-02T08:22:04+00:00","dateModified":"2014-10-21T16:30:42+00:00","breadcrumb":{"@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/enormous-perfomance-problems\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/theeventscalendar.com\/support\/forums\/topic\/enormous-perfomance-problems\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/enormous-perfomance-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":"Enormous Perfomance 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\/782363","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":0,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/782363\/revisions"}],"wp:attachment":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/media?parent=782363"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}