grid view takes ~8 seconds to load, everything else less than a second

[Sam]

I am noticing a slow-down with the grid view of my ECP Pro (2.0.4) installation.

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).

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.

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.

I monitored the queries to the database, and I can see that a query like this runs for every day of the month:

SELECT 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


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.

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.

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?

I have really enjoyed using the plugin so far, thanks for your hard work

[Jonah]

Hey Sam, great question. I need to check with a developer to get the scoop on this. Stay tuned.

[Sam]

Has there been any further information on this issue?
This could be a big deterrent for long-term use
Especially in situations where the calendar needs to be used for historical reference, and past events can’t be deleted
I have managed to put a band-aid on it by using W3 Total Cache– but this only helps so much, one user on occasion will still experience the slow down as the cache is being rebuilt

[Jonah]

Hey Sam, we’re looking into optimization for future versions of the plugin but cannot do anything now. It’s on our radar but I can’t give you any precise dates. We’re aware that they are some performance issues and we’ve identified numerous places where we can optimize and will be doing so but it won’t happen until a future version. That’s all I can tell you now. Thanks for bringing this to our attention!

[Quent]

I’ve just started using the calendar, and don’t see any issues to far.
However, I’m planning on using it to organize a calendar that has up to 15 or so events every day, probably an average of 8 a day.
I’ve read several accounts that make me think I made the wrong choice, and that the calendar gets super slow after a certain number of events is reached. -What is the status in making the calendar streamlined even if there are thousands of events in the system?
-Is there an easy way to clean up past events that are not recurring (say, events that are over 1 month old).

[Rob]

Hey Quent. Thanks for the note on this. Have you tried building out multiple events, to the level you mentioned? From what I’ve seen how much of a slowdown you see is contingent on a number of factors; it’s not something that is the same for everyone and changes based on host, traffic, other plugins, etc.

We are working to find a solution, but unfortunately it is a somewhat time intensive issue and we’ve only got so much development bandwidth. That being said we’re aware it is a high priority and apologize for the inconvenience anyone feels in the interim.

Quent, in your case, I’d say give it a go and see whether you begin to encounter pains at a certain level. Let us know if you do…while we’d hate to see you go, if the speed didn’t meet your needs I’d certainly be willing to issue a refund. I will note that this isn’t a particularly widespread issue and in the 2000+ PRO users alone we’ve only heard a handful of such reports.

Thanks for being patient and please let us know if you need anything else.

[Support Droid]

This topic has not been active for quite some time and will now be closed.

If you still need assistance please simply open a new topic (linking to this one if necessary)
and one of the team will be only too happy to help.

[Author]

Posts