WordPress.org

Support

Support » Plugins and Hacks » Event Organiser » [Resolved] Advice for recurring events?

[Resolved] Advice for recurring events?

  • Stephen,

    Some of my clients are churches and they have recurring events that happen every week, all year long, year after year.

    Do you have any recommendations for managing those events in such a way that doesn’t bog their sites down, fill up the databases, etc., but is still not too complicated for non-web savvy users?

    Thanks!
    John

    http://wordpress.org/extend/plugins/event-organiser/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Stephen Harris

    @stephenharris

    Hi John,

    There’s no database clean up for dates unless an event is deleted (not trashed)- but there isn’t much to worry about. The dates are stored in a separate table – so lots of dates does not clog up the wp_posts table for instance.

    With that in mind, only event queries would be effected even if the dates table became ‘bloated’ – but even then queries are either by ID or date and both are indexed. Also if, say, you have 50 events, recurring every week for the next 50 years, that’s 50*52*50 = 130000 rows in the dates table – this is small fry for databases which should be able to handle millions of rows.

    In short, the effect on performance should be negligible. Deleting an event will remove the dates from the table – but generally deleting stuff from databases doesn’t improve performance.

    An event ‘clean up’ is only really necessary if its a user-interface issue, but I think (I hope), EO handles events in a way that avoids that.

    Good to hear and know!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘[Resolved] Advice for recurring events?’ is closed to new replies.
Skip to toolbar