I am noticing a slow-down with the grid view of my ECP Pro (2.0.4) installation.<\/p>\n
I understand that there is a confirmed AJAX speed issue, but in this instance I am talking about direct page loads from URL and not navigating via AJAX (although that is slow too).<\/p>\n
It takes about 8 seconds to load grid view. I measured this using the Net panel in FireBug, and I can see that it is not a js or other file causing the problem. I also changed the theme to Twentyeleven to remove any theme-related influences.<\/p>\n
The slow-down seems to have gradually gotten worse over time, which makes me think it might be query-related (as the number of events on the calendar increase). There are 1,700 events on the calendar, and a month may have as many as 50 events. I did compare the time it took to load grid view with a month full of events vs a month with no events– they both load equally slow.<\/p>\n
I monitored the queries to the database, and I can see that a query like this runs for every day of the month: It takes about 200-300 MS to run this query directly on the database server, multiplying that by 30 days in a month might explain the 8 second load times.<\/p>\n I am running WordPress on Server 2008 with IIS\/PHP\/FastCGI. Another server is running Server 2008 with MySQL installed. There are other applications running on the web server that are using the same database server as WordPress. The other WordPress plugins, pages, and entire other applications are functioning fast– despite large\/complicated queries.<\/p>\n Could this be an issue of query optimization? I can’t imagine how slow things could get with 5,000 or more events in the database. Is there anything I can do to help remedy this situation?<\/p>\n I have really enjoyed using the plugin so far, thanks for your hard work<\/p>\n","protected":false},"template":"","class_list":["post-17398","topic","type-topic","status-closed","hentry"],"yoast_head":"\n
\n
\nSELECT wp_3_posts.*, eventStart.meta_value as EventStartDate, IFNULL(DATE_ADD(CAST(eventStart.meta_value AS DATETIME), INTERVAL eventDuration.meta_value SECOND), eventEnd.meta_value) as EventEndDate FROM wp_3_posts LEFT JOIN wp_3_postmeta as eventStart ON( wp_3_posts.ID = eventStart.post_id AND eventStart.meta_key = '_EventStartDate') LEFT JOIN wp_3_postmeta as eventDuration ON( wp_3_posts.ID = eventDuration.post_id AND eventDuration.meta_key = '_EventDuration') LEFT JOIN wp_3_postmeta as eventEnd ON( wp_3_posts.ID = eventEnd.post_id AND eventEnd.meta_key = '_EventEndDate') WHERE 1=1 AND wp_3_posts.post_type = 'tribe_events' AND (wp_3_posts.post_status = 'publish') AND ((eventStart.meta_value >= '2012-03-03 00:00:00' AND eventStart.meta_value = '2012-03-03 00:00:00' AND eventStart.meta_value <= '2012-03-03 23:59:59' ) OR (eventStart.meta_value = '2012-03-03 23:59:59' )) ORDER BY DATE(eventStart.meta_value) ASC, TIME(eventStart.meta_value) ASC LIMIT 0, 10
\n<\/code><\/p>\n