My host will no longer allow to me use The Events Calendar due to high SQL usage. See their message below. What can be done to resolve this so I can continue to use your plugin?<\/p>\n
The query they mention is very expensive and is run on probably hundreds of posts at once. The query is getting lat and long coordinates. Maps only appear on single event pages. If this expensive query must exist, it should only be run on single event page for one post only.<\/p>\n
Here is your MySQL usage for the past few hours: http:\/\/take.ms\/Q3Rgn
\nSo far, this peak has lasted for over 4 hours.<\/p>\n
On average a regular account with WP websites use around 0.01~0.02 where your account usage is 1.66 which means you are much over the average. Your MySQL usage with this plugin disabled is less than 0.01.<\/p>\n
We will also attach the currently SQL query (as a txt file) which is running non stop while the usage is extremely high.<\/p>\n
We cannot allow this to continue any further.<\/p>\n
We have disabled your plugin for the last time.<\/p>\n
Here is another screenshot of the MySQL usage for the past hour after we have disabled the plugin: http:\/\/take.ms\/Tb8BM<\/p>\n","protected":false},"template":"","class_list":["post-1410753","topic","type-topic","status-closed","hentry"],"yoast_head":"\n