|
motio
|
September 18, 2018 at 5:33 am
Hi,
we love Event Espresso and we were able to add many features that makes our work easier. So thank you you for the great work.
We are working with Event Espresso for almost a year and we are heaving almost 200 events that are managed through Event Espresso. Because we have so many events, I’ve noticed that it takes a while to load the events table list. We are using the “Events Table View Template” Plugin in which we filter the events for a particular purpose, for example if the event is on sale. With this approach it is probably checking every event for the if statement.
What would be the best/easiest way to decrease the loading time? Is there a way to preselect the events I want to load?
|
|
Josh
|
September 18, 2018 at 7:22 am
Hi,
You mention that you filter the events to see if the event is on sale. Does the page load more quickly if you remove that filter? If that filter is doing a join on the ticket table that would slow things down.
|
|
motio
|
September 18, 2018 at 7:52 am
Hi Josh,
to filter the event I’ve created templates in the theme folder. If I comment the if statement out it is still slow.
I’ve also tried the [ESPRESSO_EVENTS_TABLE_TEMPLATE] shortcode and it was also very slow. It takes 15 seconds to reload the page with 140 events. It is the same time with if statement.
I have an page with two event tables for a quick look and to organize the events. For that page with to event tables it takes 35 seconds to reload the page.
|
|
Josh
|
September 18, 2018 at 7:57 am
The other approach would be to use a better server. Someone else was having the same issue where they had a calendar shortcode, a grid shortcode, and and a table shortcode all on the same page. The page could take over 30 seconds to load. Then they switched their hosting from Network solutions to Kinsta and the page loads in under 1 second.
Also, on any page where you have over 100 events, you should probably limit the page to one shortcode.
|
|
motio
|
September 18, 2018 at 8:19 am
we are planing to move to a better server next year. Is there an other way to optimize the performance till than. Is it possible to use the wp_query function to filter the events or would it be the same result?
|
|
Josh
|
September 18, 2018 at 8:32 am
It is already using the wp_query class, that’s what’s doing the query under the hood of the models system.
|
|
motio
|
September 18, 2018 at 8:50 am
Would you recommend using plugins like “WP Super Cache” or “W3 Total Cache”? Do I have to think about something by using those plugins in Combination with Event Espresso?
|
|
Josh
|
September 18, 2018 at 8:51 am
WP Super Cache is recommended, and its default settings will not interfere with Event Espresso because WP Super Cache checks for the DONOTCACHEPAGE constant that’s set by Event Espresso core.
|
|
motio
|
September 18, 2018 at 8:54 am
So it will cache again if I edit an event? Than this would solve the issue till wie move…
|
|
Josh
|
September 18, 2018 at 9:00 am
I’m pretty sure you would need to manually reset the cache after you make an edit to an event.
|
