Posted: November 21, 2014 at 11:11 am
I’ve been using EE3 for a couple years and have over 800 events and over 20,000 attendees. There are currently 61 active events.
I have several categories of events and am finding both the [EVENT_LIST] and [EVENT_CUSTOM_VIEW] shortcodes both take over 5 seconds to run on the server before returning html to the browser.
When I run it locally on my dev site using MAMP PRO, it still takes over 4 seconds.
Can you recommend anything to improve the speed?
You should be able to cache those pages since they’re mostly static content, unless you’re showing how many tickets are left for each event. If you go the caching route, please be sure to disable caching for the main registration page as well as the payment pages.
Along with that, if you view the source of the page, it will have a little html comment near the footer that says how many queries x how much time it took to do the query. You might also be able to reduce the number of queries as well be removing pars of the query that you aren’t using. For example if you aren’t displaying venue info, you can remove any joins on the venue tables.
However, your suggestion about removing the unneeded joins resulted in a decrease from over 5 seconds to 0.5 seconds. Makes me wonder if the database has a problem, or is not optimized or something.
In case anyone is interested, here are the before and after queries:
Default Query (inside plugins/custom-templates/index.php):
Simplified Query (0.581 seconds including other queries on the page):
Thanks for sharing!
The support post ‘Event List Extremely Slow (EE3)’ is closed to new replies.
Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.