WordPress.org

Ready to get started?Download WordPress

Forums

Event Organiser
[resolved] Advice for recurring events? (3 posts)

  1. John Sundberg
    Member
    Posted 1 year ago #

    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/

  2. Stephen Harris
    Member
    Plugin Author

    Posted 1 year ago #

    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.

  3. John Sundberg
    Member
    Posted 1 year ago #

    Good to hear and know!

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic