Need honest answer concerning database response

[Steven W]

This is just a question–not urgent, but necessary… The Events Calendar is such a stable piece of code, I’m thinking about using it in a way for which it perhaps wasn’t intended. Basically, this client would wind up having many hundreds, if not thousands of “events” on the calendar. My concern is whether having that many TEC records (i.e., potentially thousands–with no archiving of “past” events) would create any db latency issues on the front end. If so, I’m cool with it (as I said, this would be a use that probably wasn’t really envisioned when it was built), but I do need an honest opinion about whether this is feasible–before I go making promises…

[Geoff]

Hey Mark, and thanks for reaching out! I’m totally willing to help you out here with as honest an answer as I can.

The truth is that there’s always  concern when we’re talking about thousands of posts, not just for The Events Calendar, but any WordPress post type in general.

On our side of things though–and where it comes to events–we have a good number of customers running sites with events that range in the thousands with no performance issues whatsoever.

That isn’t to say we haven’t seen trouble in the past. For example, we noticed a huge lag in performance in our Month View when we released 3.11 and subsequently put a lot of work into fixing that in 3.11. Things seem to be running smoothly since that release as far as performance.

The times I see performance come up lately is when thousands of events are being used on a shared server. So, if you’re looking at a site with a ton of data and requires a lot of resources, I’d recommend going with a dedicated hosting plan to ensure you avoid bottlenecks.

Does this help answer your questions? Let me know if you have any others or if I can clarify on anything here and I’d be happy to. 🙂

Cheers!
Geoff

[Steven W]

Thanks, Geoff. Yes, it answers my question. I’m inclined to give it a go, knowing you all are behind it. This client is on a shared server, but their user-base is quite small (probably fewer than five thousand unique visitors and fewer than forty or fifty simultaneous visitors), so I think it’ll be OK.

Thanks for your honesty. It means a lot.

[Geoff]

My pleasure man! Please do feel free to hit us back up if you notice something strange. We take performance seriously and always interested in seeing use cases that challenge us to make things even better.

[Author]

Posts