[Summer]

It seems the wp_options table in my site was very large, approx 590mb

Ran this command in phpMyAdmin

DELETE FROM wp_options WHERE option_name LIKE ‘%transient%’

Whole site is faster now. Not sure what caused the huge # of _transient_ rows to get added to this table, but it was the cause.

• This reply was modified 8 years, 6 months ago by Summer.

[Summer]

Our site is still terribly slow. on iOS it’s so slow to respond that in some cases it can’t be displayed. We have only a tiny bit of static content (normal posts) but our database is > 600mb. It seems that Events Calendar is grabbing up a ton of content, and because the database has become so large, all pages in the site are now slow.

We have another site hosted with the same hosting company, same version of PHP, but without the Events Calendar plugin. Performance on that site is totally fine.

We reduced some of the display settings as follows:
Number of events to show per page: 10
Clean up recurring events after: 1 month
Create recurring events in advance for: 2 months
Month view events per day: 3
Enable months view cache: yes

We have wp-supercache plugin installed and enabled
We have wp-optimize installed and ran it’s recommended database cleanup routines

In some cases it seems like caching is working and page loads are good, but if the page is not cached because something has changed and you are visiting that changed page for the first time, it is ridiculously slow (takes minutes to load).

Any advice is much appreciated. It would be great to get some specific advice and not links to generic articles.

[Author]

Posts