Hi, I also have submitted a sales request for information about Enterprise work. But in the meantime, my support at WP Engine has asked me to reach out to you regarding the extreme server load that is being caused by the load below. <\/p>\n
For a little context, we publish a large, well-trafficked “Things to Do” website. On days like July 4th, we can easily have up to 80 events. We typically have 10 to 60 events on every day. I recognized this is likely outside the scale of what the plugin was designed to do (we’re looking for a replacement – hence the sales request for Enterprise work). But in the meatime, it’s beating down our page load and making it almost impossible for my staff to update the site. <\/p>\n
According to WP Engine, here is the guilty query below the line. Can you tell me what you recommend? I will pass this along to WP Engine to help get this resolved. <\/p>\n
2078020 houston365 127.0.0.1:54942 wp_houston365 Query 0 SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*, MIN(wp_postmeta.meta_value) as EventStartDate, MIN(tribe_event_end_date.meta_value) as EventEndDate FROM wp_posts LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) LEFT JOIN wp_postmeta AS mt2 ON (wp_posts.ID = mt2.post_id AND mt2.meta_key = ‘_EventHideFromUpcoming’ ) 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 = ‘_EventEndDate’ ) WHERE 1=1 AND wp_posts.ID NOT IN (73435) AND ( wp_postmeta.meta_key = ‘_EventStartDate’ AND ( ( mt1.meta_key = ‘_EventStartDate’ AND CAST(mt1.meta_value AS DATETIME) < ‘2017-07-06 11:00:00’ ) OR ( ( mt1.meta_key = ‘_EventStartDate’ AND CAST(mt1.meta_value AS DATETIME) = ‘2017-07-06 11:00:00’ ) AND mt1.post_id < 73435 ) ) AND mt2.post_id IS NULL ) AND wp_posts.post_type = ‘tribe_events’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘tribe-ea-success’ OR wp_posts.post_status = ‘tribe-ea-failed’ OR wp_posts.post_status = ‘tribe-ea-schedule’ OR wp_posts.post_status = ‘tribe-ea-pending’ OR wp_posts.post_status = ‘tribe-ea-draft’) GROUP BY wp_posts.ID ORDER BY EventStartDate DESC, wp_posts.ID DESC LIMIT 0, 1 \/* From [365thingsinhouston.com\/calendar\/shadow-puppet-theatre-woodlands-childrens-museum-2\/2017-07-06\/] in [\/nas\/content\/live\/houston365\/wp-content\/plugins\/the-events-calendar\/src\/Tribe\/Query.php:1017] *\/<\/p>\n","protected":false},"template":"","class_list":["post-1316540","topic","type-topic","status-closed","hentry"],"yoast_head":"\n