[EventCalendar] SLOW QUERIES caused by EC3

[Hoboken411]

Hello Everyone!

 

I have a relatively popular blog with between 1MM - 2MM pageviews per month.

 

I use EC3 (3.1.0) on a 2.0.11 version of WP.

 

I only use the sidebar function showing the next 10 days of events, that's
all.

 

However, since my site has steadily gained in popularity, I've been
suffering MySQL performance issues. After weeks of experimentation and
analysis, I've come to determine that the EC3 plugin is the source of the
SLOW SQL queries. Without boring you with the exact processes, it seems that
the EC3 plugin is causing frequent high CPU% loads with the heavy LEFT JOINS
in the databases.

 

My questions are simple:

 

1.       If the EC3 plugin creates a table with the URL and date, I would
assume it only has to perform the join when a post is saved with an event.
Why is it continually bogging down the database?

2.       Does filtering cause this? The plugin doesn't delete expired events
for one thing (I constantly have to go back and delete the event from the
original posts from time to time), and what about future events? Does the
filtering (i.e., "if event=longer than 10 days, then do not display") cause
the CPU load?

 

Any advice or suggestions would be greatly appreciated. I love the plugin
otherwise!

 

Look forward to your responses. 

 

Perry

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://penguin.firetree.net/pipermail/eventcalendar/attachments/20080308/57b4bfb8/attachment.html