Calendar Performance for calendar with a lot of events

[Russell]

Hi,

We have a big event calendar which has up to 20 events per day in Ibiza. We’ve got a custom solution (http://myibiza.tv/calendar) which has been designed to load as fast as it could.

Unfortunately this is quiet lacking so we want to go back to using the built in calendar from you guys, but the performance is terrible, even with just 3 events per day loading:

https://myibiza.tv/events/

I’ve got the html caching turned on in settings and this doesn’t effect it too much. I’ve also looked into your support archives and seen the various posts you’ve made about the different caching types etc. We’re on WPEngine with all of the cache turned on as well as Cloudflare – but still the performance of this page isn’t acceptable.

An option I’ve briefly explored is caching the calendar to HTML like so: http://wesbos.com/simple-php-page-caching-technique/

However putting this code in the month.php template it still hangs for ages before loading – so I can assume the queries for the events are happening before this point.

Aside from that I’m at a loss as to how to improve the performance of this page. Is there any advice you could offer?

Thanks
Russ

[Russell]

Also it sometimes gets a 502 error when loading as well (See attached).

[Jennifer]

Hi Russell,

Thanks for reaching out! I’m sorry you’re running into these issues, but hopefully we can get some improvements in performance here.

The first thing I would suggest is taking a look at this knowledge article on things to consider to help improve performance.

Second, going under Events > Settings > General and reducing the amount of time into the future that recurring events are created as well as the amount of time before past events are deleted. If you can reduce the overall amount of events you have, that should help somewhat.

The Query Monitor plugin is great for identifying slow queries, so it may be worthwhile to install that and see what kind of results you get on the events page. Please copy/paste the results here so that I can take a look.

I do see that your versions of all three of our plugins are a little bit behind, so I would recommend updating those to the most recent versions as well (although I don’t think that will solve this issue – still a good idea!).

Thanks,

Jennifer

[Russell]

Hey Jennifer,

Thanks for the advice, I’ve read through those articles you’ve mentioned
before posting but unfortunately they’re not able to fix the issues we’re
experiencing.

The events are all individual rather than recurring, the WPEngine guys
looked into it all for me and they say it’s because each event is making a
call to the database each time the page loads.

Is it possible to optimise that database call so that it only runs once and
builds an array of the events, or ideally cache the calendar page as static
HTML like I mentioned?

Cheers
Russ

—

* Russell Meakin * Director

*EVENTS* *• **SOCIAL MEDIA* *• **DESIGN **• **MARKETING*

*MYIBIZA * • *MY**VEGAS* •
*MY**GUERNSEY* • *MY**CROATIA*

IBZ.TV LTD • PARAGON HOUSE • ST PETER PORT •
GUERNSEY • GY1 2NU

[Jennifer]

Hi Russell,

I checked with the team, and while we currently have internal tickets open to improve our queries, there unfortunately isn’t anything else we can recommend at the moment in the way of changing the queries. However, if you take a look at our list of recommended developers, Don Grover is great with performance customizations, so he may be able to help you out!

I’m sorry I don’t have a better answer for you here, but please let me know if you have any other questions!

Thanks,

Jennifer

[Support Droid]

Hey there! This thread has been pretty quiet for the last three weeks, so we’re going to go ahead and close it to avoid confusion with other topics. If you’re still looking for help with this, please do open a new thread, reference this one and we’d be more than happy to continue the conversation over there.

Thanks so much!
The Events Calendar Support Team

[Author]

Posts