We’re really struggling with slow calendar and events performance. It’s really having a negative impact on our business.<\/p>\n
The site has about 2000 published events.<\/p>\n
We’ve done some testing with Query Monitor and found the following results, some of which seem extraordinary.<\/p>\n
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.<\/p>\n
Attached are several screenshots, listed below with comments. The screenshots were taken with a logged in user, so are un-cached pages <\/p>\n
FE-HomePage – this shows the home page. It took about half a second to load and required 51 queries. Seems reasonable.<\/p>\n
FE-KayakPage – This is the Kayaking & Canoeing page. About .6 seconds to load, and 63 queries. Seems reasonable.<\/p>\n
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. <\/p>\n
Is it related to https:\/\/theeventscalendar.com\/support\/forums\/topic\/troubleshooting-slow-calendar-other-category-events-in-source\/ or different?<\/p>\n
FE-WeekView – This is the week view of the calendar. It loads in about 2.5 seconds and requires 195 database queries. Seems reasonable.<\/p>\n
BE-Home Page – 1.5 seconds to load, about 200 queries<\/p>\n
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.<\/p>\n
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?<\/p>\n
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.<\/p>\n","protected":false},"template":"","class_list":["post-1322794","topic","type-topic","status-closed","hentry"],"yoast_head":"\n