Memories, Queries, an events

[Mathias Cordina]

We’re really struggling with slow calendar and events performance. It’s really having a negative impact on our business.

The site has about 2000 published events.

We’ve done some testing with Query Monitor and found the following results, some of which seem extraordinary.

If you’re not familiar with Query Monitor, it provides a toolbar at the top of the page with the following summary information: time to load the page, peak memory, time spent talking to the database, number of database queries required by the page.

Attached are several screenshots, listed below with comments. The screenshots were taken with a logged in user, so are un-cached pages

FE-HomePage – this shows the home page. It took about half a second to load and required 51 queries. Seems reasonable.

FE-KayakPage – This is the Kayaking & Canoeing page. About .6 seconds to load, and 63 queries. Seems reasonable.

FE-MonthView – This is the month view of the calendar. It took almost 2 minutes to load, had peak memory usage of 370MB, and required a whopping 10,000 queries to generate. Seems insane.

Is it related to https://theeventscalendar.com/support/forums/topic/troubleshooting-slow-calendar-other-category-events-in-source/ or different?

FE-WeekView – This is the week view of the calendar. It loads in about 2.5 seconds and requires 195 database queries. Seems reasonable.

BE-Home Page – 1.5 seconds to load, about 200 queries

BE-Orders – This is the woocommerce orders page, its set to show 20 orders. It loaded in about 2 seconds, and had just under 500 queries. It’s about on par with other ecommerce sites we manage.

BE-Events – This is the events page. It’s set to show 20 events. It took about 7 seconds to load and required 1000 queries. This seems high – why almost 50 queries for every event?

Please confirm if this is expected behaviour – the slow loads in the front and back end, or there is an issue with the calendar/events plugins.

[Mathias Cordina]

Back end screenshot (just the events page, the others had confidential information).

[Andras]

Hello Ted and thanks for reaching out!

I’m sorry about the slow loading issue in the month view. This is a tricky one. Indeed it might be partially connected to the other issue you have referenced. The other part is that you have handling quite a number of events which can definitely impact your load time, just like when you have lots of blog posts to show.

Now I checked your month view, reloaded it couple of times and usually loaded within 6-7 seconds, I believe due to caching on the server side. (I switched of browser caching.)

This article might give you some insight and possibly some tips on what you can do:

Performance considerations

Let me know if you have further questions and I’ll do my best to help.

Cheers,
Andras

[Andras]

This reply is private.

[Mathias Cordina]

Thank you Andras.

2000 events total doesn’t seem to be too many to us. How many can events calendar realistically handle?

Thank you

[Andras]

Hi Ted,

We have clients with a couple thousand events in their calendars, though I don’t know their setup from the top of my head.

If you don’t have caching – usually when logged in – then running the queries will take time with 2000 events, just like with 2000 blog posts. Caching can definitely help, not only the built-in month view caching but some caching plugin as well – which I see you have.

I will pull in another pair of eyes to take a look at this, and get a different perspective.

As for the issue you already reported, it is ticketed and we’ll be looking into that. Nico, or someone from the team will be in touch if there is any news.

Cheers,
Andras

[Andras]

Hi again,

I managed to get a different perspective on this, here’s the extra feedback.

Regarding the admin panel, Advanced Post Manager adds some extra queries, so that is something to take into account.

I see their theme is customizing our templates, so it could be worth testing for conflicts to see if using a default theme reduces the number of queries.

If testing for conflicts doesn’t change anything, asking the list of queries for that month view (in category) could show us something to look at.

In terms of what would be the number of events TEC can handle, this is something that really depends on many variables like server resources, number of events/posts, caching, etc. So difficult to say.

Hope this will help us get further. Let me know the results of the conflict test once you manage to do that.

Thanks and cheers,
Andras

[Mathias Cordina]

Hi Andras,

I tested with 2017 theme, disabled all other plugins, with and without caching plugin. Site speed is a bit better loading the month view but I got some 500 errors on first load, site takes too long to respond messages.

Logged in as an admin without cache it takes forever to load, over a minute in some cases.

[Andras]

Hi Ted,

I checked the calendar and specifically the month view. At first it loaded for 2 and a half minutes, but no errors.

Afterwards is loaded quite fast, 10-20 seconds.

Without caching – when logged in – it will always load slower, there is no cure for that.

What can still improve load times is having more server resources, more processing power. (I see you are already using a caching plugin…)

We will look into the issue which is mentioned in the thread you quoted, which should help with the category month view load times.

I am going to set the status of this ticket to “pending fix” and we will update it once the fix is released.

Cheers,
Andras

 

[Nico]

Hi there,

Just wanted to share with you that a new maintenance release (for the Week of 7th January 2018) is out, including a fix for this issue :slightly_smiling_face:

Find out more about this release → https://theeventscalendar.com/maintenance-release-week-7-january-2018/

Please update the plugins and let us know if the fix works for your site,
Best,
Nico

[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