{"id":1217070,"date":"2017-01-11T16:56:39","date_gmt":"2017-01-12T00:56:39","guid":{"rendered":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/event-tickets-causing-slow-loading-on-woocommerce-memberships-admin-page\/"},"modified":"2017-02-06T19:05:32","modified_gmt":"2017-02-07T03:05:32","slug":"event-tickets-causing-slow-loading-on-woocommerce-memberships-admin-page","status":"closed","type":"topic","link":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/event-tickets-causing-slow-loading-on-woocommerce-memberships-admin-page\/","title":{"rendered":"Event Tickets Causing Slow Loading on WooCommerce Memberships Admin Page"},"content":{"rendered":"<p>Hi, I&#8217;m having an issue with Event Tickets and WooCommerce Memberships &#8211; in terms of the expected functionality everything works really great, so we&#8217;re very happy with the plugin on that front! <\/p>\n<p>However, there is a bit of a performance issue with the plugin when it comes to a particular screen on the back-end of the website. When visiting the WooCommerce &gt; Memberships page in wp-admin (\/wp-admin\/edit.php?post_type=wc_user_membership) it seems that the Event Tickets plugin is running some queries that are contributing rather significantly to the load time of the page. It is by far the slowest page in the admin area of the website, clocking in around 6-10 seconds on average. I checked out the queries using Query Monitor and the two slowest queries are coming from Event Tickets.<\/p>\n<p>I was wondering if there is any way to prevent Event Tickets from running queries on this page, as there doesn&#8217;t seem to be any information related to events \/ tickets displayed on the page anyway so theoretically these queries don&#8217;t need to be running at all! I found that deactivating the plugin helped speed up the page quite a bit, but we really want to keep the plugin and functionality it provides. <\/p>\n<p>There are numerous intances of queries similar to this:<\/p>\n<p>SELECT DISTINCT as_posts.ID<br \/>\nFROM as_posts<br \/>\nINNER JOIN as_postmeta<br \/>\nON ( as_posts.ID = as_postmeta.post_id )<br \/>\nWHERE 1=1<br \/>\nAND ( ( as_postmeta.meta_key = &#8216;_tribe_rsvp_for_event&#8217;<br \/>\nAND as_postmeta.meta_value = &#8216;600&#8217; ) )<br \/>\nAND as_posts.post_type = &#8216;tribe_rsvp_tickets&#8217;<br \/>\nAND ((as_posts.post_status = &#8216;publish&#8217;))<br \/>\nGROUP BY as_posts.ID<br \/>\nORDER BY as_posts.post_date DESC<\/p>\n","protected":false},"template":"","class_list":["post-1217070","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>Event Tickets Causing Slow Loading on WooCommerce Memberships Admin Page -<\/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\/event-tickets-causing-slow-loading-on-woocommerce-memberships-admin-page\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Event Tickets Causing Slow Loading on WooCommerce Memberships Admin Page -\" \/>\n<meta property=\"og:description\" content=\"Hi, I&#8217;m having an issue with Event Tickets and WooCommerce Memberships &#8211; in terms of the expected functionality everything works really great, so we&#8217;re very happy with the plugin on that front! However, there is a bit of a performance issue with the plugin when it comes to a particular screen on the back-end of [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/event-tickets-causing-slow-loading-on-woocommerce-memberships-admin-page\/\" \/>\n<meta property=\"article:modified_time\" content=\"2017-02-07T03:05:32+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\/event-tickets-causing-slow-loading-on-woocommerce-memberships-admin-page\/\",\"url\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/event-tickets-causing-slow-loading-on-woocommerce-memberships-admin-page\/\",\"name\":\"Event Tickets Causing Slow Loading on WooCommerce Memberships Admin Page -\",\"isPartOf\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\"},\"datePublished\":\"2017-01-12T00:56:39+00:00\",\"dateModified\":\"2017-02-07T03:05:32+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/event-tickets-causing-slow-loading-on-woocommerce-memberships-admin-page\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/event-tickets-causing-slow-loading-on-woocommerce-memberships-admin-page\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/event-tickets-causing-slow-loading-on-woocommerce-memberships-admin-page\/#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\":\"Ticket Products\",\"item\":\"https:\/\/theeventscalendar.com\/support\/forums\/forum\/event-tickets\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Event Tickets Plus\",\"item\":\"https:\/\/theeventscalendar.com\/support\/forums\/forum\/event-tickets\/event-tickets-plus\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Event Tickets Causing Slow Loading on WooCommerce Memberships Admin Page\"}]},{\"@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":"Event Tickets Causing Slow Loading on WooCommerce Memberships Admin Page -","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\/event-tickets-causing-slow-loading-on-woocommerce-memberships-admin-page\/","og_locale":"en_US","og_type":"article","og_title":"Event Tickets Causing Slow Loading on WooCommerce Memberships Admin Page -","og_description":"Hi, I&#8217;m having an issue with Event Tickets and WooCommerce Memberships &#8211; in terms of the expected functionality everything works really great, so we&#8217;re very happy with the plugin on that front! However, there is a bit of a performance issue with the plugin when it comes to a particular screen on the back-end of [&hellip;]","og_url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/event-tickets-causing-slow-loading-on-woocommerce-memberships-admin-page\/","article_modified_time":"2017-02-07T03:05:32+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\/event-tickets-causing-slow-loading-on-woocommerce-memberships-admin-page\/","url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/event-tickets-causing-slow-loading-on-woocommerce-memberships-admin-page\/","name":"Event Tickets Causing Slow Loading on WooCommerce Memberships Admin Page -","isPartOf":{"@id":"https:\/\/theeventscalendar.com\/support\/#website"},"datePublished":"2017-01-12T00:56:39+00:00","dateModified":"2017-02-07T03:05:32+00:00","breadcrumb":{"@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/event-tickets-causing-slow-loading-on-woocommerce-memberships-admin-page\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/theeventscalendar.com\/support\/forums\/topic\/event-tickets-causing-slow-loading-on-woocommerce-memberships-admin-page\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/event-tickets-causing-slow-loading-on-woocommerce-memberships-admin-page\/#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":"Ticket Products","item":"https:\/\/theeventscalendar.com\/support\/forums\/forum\/event-tickets\/"},{"@type":"ListItem","position":4,"name":"Event Tickets Plus","item":"https:\/\/theeventscalendar.com\/support\/forums\/forum\/event-tickets\/event-tickets-plus\/"},{"@type":"ListItem","position":5,"name":"Event Tickets Causing Slow Loading on WooCommerce Memberships Admin Page"}]},{"@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\/1217070","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\/1217070\/revisions"}],"predecessor-version":[{"id":1230293,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1217070\/revisions\/1230293"}],"wp:attachment":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/media?parent=1217070"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}