{"id":816400,"date":"2014-10-17T14:00:22","date_gmt":"2014-10-17T21:00:22","guid":{"rendered":"http:\/\/tri.be\/support\/forums\/topic\/worrying-performance-issue-long-queries\/"},"modified":"2014-11-06T07:56:31","modified_gmt":"2014-11-06T15:56:31","slug":"worrying-performance-issue-long-queries","status":"closed","type":"topic","link":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/worrying-performance-issue-long-queries\/","title":{"rendered":"Worrying Performance issue: Long Queries"},"content":{"rendered":"

Hey there,
\nOne of my clients sites has slowed down considerably – to the point that it is a problem. We noticed a lot of database queries & CPU being at 100% capacity…on a dedicated server with 2 cores and almost no traffic on the site.
\nAfter investigating, we found that these issues come from an Events Calendar issue:<\/p>\n

Fri Oct 17 20:03:38 2014] [error] [client 66.162.212.19] LONG QUERY (1028 characters long generated in \/nas\/wp\/www\/cluster-2250\/hipica\/wp-content\/plugins\/the-events-calendar\/lib\/tribe-event-query.class.php:841):<\/p>\n

That’s only one example – there are many more in the error log.<\/p>\n

We also moved the site to WPengine, to test. They helped us again to investigate the problem, and also came to the conclusion that Events Calendar is the reason for queries and performance issues. The support technician further told me, that these performance issues of Events Calendar are well known at WPengine.<\/p>\n

We do not have many events, maybe 60 & none re-occurring. <\/p>\n

Please help<\/p>\n

Thanks<\/p>\n

Nils<\/p>\n

P.s.: Otherwise, the plugin is fantastic & I really love it!!!<\/p>\n","protected":false},"template":"","class_list":["post-816400","topic","type-topic","status-closed","hentry"],"yoast_head":"\nWorrying Performance issue: Long Queries -<\/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\/worrying-performance-issue-long-queries\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Worrying Performance issue: Long Queries -\" \/>\n<meta property=\"og:description\" content=\"Hey there, One of my clients sites has slowed down considerably – to the point that it is a problem. We noticed a lot of database queries & CPU being at 100% capacity…on a dedicated server with 2 cores and almost no traffic on the site. After investigating, we found that these issues come from […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/worrying-performance-issue-long-queries\/\" \/>\n<meta property=\"article:modified_time\" content=\"2014-11-06T15:56:31+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\/worrying-performance-issue-long-queries\/\",\"url\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/worrying-performance-issue-long-queries\/\",\"name\":\"Worrying Performance issue: Long Queries -\",\"isPartOf\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\"},\"datePublished\":\"2014-10-17T21:00:22+00:00\",\"dateModified\":\"2014-11-06T15:56:31+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/worrying-performance-issue-long-queries\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/worrying-performance-issue-long-queries\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/worrying-performance-issue-long-queries\/#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\":\"Additional Help\",\"item\":\"https:\/\/theeventscalendar.com\/support\/forums\/forum\/others\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Translations\",\"item\":\"https:\/\/theeventscalendar.com\/support\/forums\/forum\/others\/translation\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Worrying Performance issue: Long Queries\"}]},{\"@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":"Worrying Performance issue: Long Queries -","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\/worrying-performance-issue-long-queries\/","og_locale":"en_US","og_type":"article","og_title":"Worrying Performance issue: Long Queries -","og_description":"Hey there, One of my clients sites has slowed down considerably – to the point that it is a problem. We noticed a lot of database queries & CPU being at 100% capacity…on a dedicated server with 2 cores and almost no traffic on the site. After investigating, we found that these issues come from […]","og_url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/worrying-performance-issue-long-queries\/","article_modified_time":"2014-11-06T15:56:31+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\/worrying-performance-issue-long-queries\/","url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/worrying-performance-issue-long-queries\/","name":"Worrying Performance issue: Long Queries -","isPartOf":{"@id":"https:\/\/theeventscalendar.com\/support\/#website"},"datePublished":"2014-10-17T21:00:22+00:00","dateModified":"2014-11-06T15:56:31+00:00","breadcrumb":{"@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/worrying-performance-issue-long-queries\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/theeventscalendar.com\/support\/forums\/topic\/worrying-performance-issue-long-queries\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/worrying-performance-issue-long-queries\/#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":"Additional Help","item":"https:\/\/theeventscalendar.com\/support\/forums\/forum\/others\/"},{"@type":"ListItem","position":4,"name":"Translations","item":"https:\/\/theeventscalendar.com\/support\/forums\/forum\/others\/translation\/"},{"@type":"ListItem","position":5,"name":"Worrying Performance issue: Long Queries"}]},{"@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\/816400","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\/816400\/revisions"}],"wp:attachment":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/media?parent=816400"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}