Support

Home Forums Event Espresso Premium Slow Database

Slow Database

Posted: December 27, 2016 at 8:46 pm

Viewing 3 reply threads


denise

December 27, 2016 at 8:46 pm

Since upgrading to the latest ee4, the database connections and updating events is taking a really long time. Is there anything I can do about this?

Thanks,
Denise


Josh

  • Support Staff

December 28, 2016 at 8:47 am

Hi Denise,

You can run an optimization script for the database, and even repair the tables if they are damaged. Here’s a link to a guide from Dreamhost hosting that can be followed for any host that gives you access to your database:

https://help.dreamhost.com/hc/en-us/articles/215036388-How-do-I-optimize-my-database-


denise

January 12, 2017 at 8:47 pm

HI Josh,

I ran the optimizations from the dreamhost link. Thank you. But that doesn’t seems to have made much of a difference. The Calendar seems to update very slowly.

Is there anything else I can try?

Thanks
Denise


Josh

  • Support Staff

January 13, 2017 at 7:46 am

Hi Denise,

I checked the calendar page on your website and the slow loading calendar doesn’t appear to be because of the database. One factor for the slow speeds is the number of image files being loaded. Every event there has a feature image, and some of those events have images inside their tooltip. Image files are loaded on separate http requests. That all adds up. There’s some information about how you can reduce the number of http requests here:
https://yoast.com/reduce-http-requests-wordpress/
You could also try optimizing those images a bit by using a tool like smush.it.

A few other things you could try would be to set the calendar to not display expired events. That way later in the month, the initial page view will load fewer pictures. You can also try caching that page by using a plugin like WP Super Cache.

Viewing 3 reply threads

The support post ‘Slow Database’ 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.

Event Espresso