Support » Plugin: Event Organiser » Advice for recurring events?

  • Resolved John Sundberg



    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?


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


    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 ‘Advice for recurring events?’ is closed to new replies.