[kgemmell]

Thanks for the reply Brook,

That article was helpful and I have updated the settings to reflect their optimization suggestions. The virtual server is a shared host with about 6 sites on it. 1 Processor, 1.5G Memory, 64bit CentOS, 81.61GB disk space.

Biggest help though was just removing old events. I’ve created a plugin that automatically removes non recurring events when their end date has past. I’ve notice you guys already had an option in the settings for cleaning out old recurring events in the same way. You might want to expand that to include the non recurring events to just to give users an easy route to keep the number of events down.

Thanks again for the suggestions

Cheers

[kgemmell]

Solution to the problem was basically to keep the events under 1000. If you have any other suggestions that might help to make the query run more efficiently please let me know.

[Author]

Posts