{"id":1262576,"date":"2017-03-31T07:45:29","date_gmt":"2017-03-31T14:45:29","guid":{"rendered":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/recurring-event-series-performance-and-sort-issues\/"},"modified":"2017-04-03T18:39:55","modified_gmt":"2017-04-04T01:39:55","slug":"recurring-event-series-performance-and-sort-issues","status":"closed","type":"topic","link":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/recurring-event-series-performance-and-sort-issues\/","title":{"rendered":"Recurring Event Series Performance and sort issues"},"content":{"rendered":"<p>Hi,<\/p>\n<p>Since the last update performance on our production server retrieving a recurring series of events is unacceptable. The page often timeout&#8221;Page Unresponsive Kill or Wait&#8221; and can take several attempts and 2-3 minutes  before it loads (1 minute on a stand alone dev server). When it does eventually load in the &#8216;Event will not occur&#8217; sectionthe event dates are randomised and not sorted in date order. As we have a considerable number of recurring events it occurs to me that there may be an indexing issue on the table. This would account for the time taken to search for recurring events as well as the fact when they are displayed they are not in any form of date order. This seems to have only occurred since the last release as event series are edited and created every 3-4 weeks.<\/p>\n<p>Cheers<br \/>\nPhil<\/p>\n","protected":false},"template":"","class_list":["post-1262576","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>Recurring Event Series Performance and sort issues -<\/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\/recurring-event-series-performance-and-sort-issues\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Recurring Event Series Performance and sort issues -\" \/>\n<meta property=\"og:description\" content=\"Hi, Since the last update performance on our production server retrieving a recurring series of events is unacceptable. The page often timeout&#8221;Page Unresponsive Kill or Wait&#8221; and can take several attempts and 2-3 minutes before it loads (1 minute on a stand alone dev server). When it does eventually load in the &#8216;Event will not [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/recurring-event-series-performance-and-sort-issues\/\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-04T01:39:55+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\/recurring-event-series-performance-and-sort-issues\/\",\"url\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/recurring-event-series-performance-and-sort-issues\/\",\"name\":\"Recurring Event Series Performance and sort issues -\",\"isPartOf\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\"},\"datePublished\":\"2017-03-31T14:45:29+00:00\",\"dateModified\":\"2017-04-04T01:39:55+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/recurring-event-series-performance-and-sort-issues\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/recurring-event-series-performance-and-sort-issues\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/recurring-event-series-performance-and-sort-issues\/#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\":\"Recurring Event Series Performance and sort issues\"}]},{\"@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":"Recurring Event Series Performance and sort issues -","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\/recurring-event-series-performance-and-sort-issues\/","og_locale":"en_US","og_type":"article","og_title":"Recurring Event Series Performance and sort issues -","og_description":"Hi, Since the last update performance on our production server retrieving a recurring series of events is unacceptable. The page often timeout&#8221;Page Unresponsive Kill or Wait&#8221; and can take several attempts and 2-3 minutes before it loads (1 minute on a stand alone dev server). When it does eventually load in the &#8216;Event will not [&hellip;]","og_url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/recurring-event-series-performance-and-sort-issues\/","article_modified_time":"2017-04-04T01:39:55+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\/recurring-event-series-performance-and-sort-issues\/","url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/recurring-event-series-performance-and-sort-issues\/","name":"Recurring Event Series Performance and sort issues -","isPartOf":{"@id":"https:\/\/theeventscalendar.com\/support\/#website"},"datePublished":"2017-03-31T14:45:29+00:00","dateModified":"2017-04-04T01:39:55+00:00","breadcrumb":{"@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/recurring-event-series-performance-and-sort-issues\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/theeventscalendar.com\/support\/forums\/topic\/recurring-event-series-performance-and-sort-issues\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/recurring-event-series-performance-and-sort-issues\/#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":"Recurring Event Series Performance and sort issues"}]},{"@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\/1262576","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\/1262576\/revisions"}],"predecessor-version":[{"id":1263655,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1262576\/revisions\/1263655"}],"wp:attachment":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/media?parent=1262576"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}