Hi There, <\/p>\n
I’ve had a look at some of the other support forums as this seems to have been a pretty common issue. <\/p>\n
The Query below seems to use up 99% of the servers resources every time it runs and if more than one user tries to visit a calendar event page the site basically dies. <\/p>\n
# Time: 160706 10:13:49
\n# User@Host: ytn_db[ytn_db] @ localhost []
\n# Thread_id: 1120 Schema: ytn_db QC_hit: No
\n# Query_time: 20.848194 Lock_time: 0.000117 Rows_sent: 34 Rows_examined: 7667238
\n# Rows_affected: 0
\nSET timestamp=1467825229;
\nSELECT tribe_event_start.post_id as ID,
\n tribe_event_start.meta_value as EventStartDate,
\n tribe_event_end_date.meta_value as EventEndDate
\n FROM wp_postmeta AS tribe_event_start
\n LEFT JOIN wp_posts ON tribe_event_start.post_id = wp_posts.ID
\n LEFT JOIN wp_postmeta as tribe_event_end_date ON ( tribe_event_start.post_id = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = ‘_EventEndDate’ )
\n WHERE tribe_event_start.meta_key = ‘_EventStartDate’
\n AND ( (tribe_event_start.meta_value >= ‘2016-06-27 00:00:00’ AND tribe_event_start.meta_value <= ‘2016-07-31 23:59:59’)
\n OR (tribe_event_start.meta_value <= ‘2016-06-27 00:00:00’ AND tribe_event_end_date.meta_value >= ‘2016-06-27 00:00:00’)
\n OR ( tribe_event_start.meta_value >= ‘2016-06-27 00:00:00’ AND tribe_event_start.meta_value <= ‘2016-07-31 23:59:59’)
\n )
\n AND wp_posts.post_status IN(‘publish’,’private’)
\n ORDER BY wp_posts.menu_order ASC, DATE(tribe_event_start.meta_value) ASC, TIME(tribe_event_start.meta_value) ASC;<\/p>\n
I noticed on some other threads that selecting the cache option in the admin settings has helped in some cases but it doesn’t seem to do the trick here. <\/p>\n
In an attempt to speed things up we tried indexing those particular tables that get queried, as they are not usually indexed by default, but that didn’t seem to help as it looks like it is building a temporary table with all the joins every time and then scanning that which is a huge amount to go through and consequently quite slow. <\/p>\n
There are currently just over 2000 events and were hoping that removing them will help the issue. I’ve also noticed that wpengine has given some people grief with this plugin. We are NOT using Wp engine but if there are any settings we can adjust on our server to help solve the issue let me know. <\/p>\n
If you have any other suggestions, patches or ideas please let me know. <\/p>\n
You can see the site here http:\/\/www.yourtownnews.ca\/<\/p>\n
I’ve currently had to disable the plugin in order to keep the site live. Let me know if you need it active to do any investigation. <\/p>\n","protected":false},"template":"","class_list":["post-1136272","topic","type-topic","status-closed","hentry"],"yoast_head":"\n