[EventCalendar] patch to add index

David Turner novalis at novalis.org
Wed May 14 18:21:16 UTC 2008


EC3 uses a lot of queries that join the wp_ec3_schedule table to the
posts table.  Unfortunately, this has very bad performance because there
is no index on the foreign key.  This patch adds one (to new installs of
ec3).  For old installs, you'll need to alter table wp_ec3_schedule add
index post_id_idx(post_id).  


-------------- next part --------------
A non-text attachment was scrubbed...
Name: improve-performance.patch
Type: text/x-patch
Size: 440 bytes
Desc: not available
Url : http://penguin.firetree.net/pipermail/eventcalendar/attachments/20080514/65d5867c/improve-performance.bin


More information about the EventCalendar mailing list