Recurring events, Is this a joke?

  • Resolved Don Gordon

    (@rippledon)


    4 years, 4 months ago

    Hello, just checking that I’m not missing something here. Is the expected behavior of a recurring event to create a database entry for every event date until the end of time, and then to load the entire result set on page load that uses a short code for the plugin? We have 16 repeating events on our site yet over 700,000 event dates in the database and on page load the entire record set is loaded and then parsed causing 100+ slow queries (all are for MEC) on the site and 25+ second load times. Please tell me this is a joke, or something that has been fixed since we created these events. All plugins are up to date, and when I disable MEC, our load times go down to 0.03 seconds.

    Events created up until the year 2110

    702161 results

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Contributor webnus

    (@webnus)

    Hi @rippledon,

    We have improved this in the latest versions of MEC. Make sure to use that.
    We have no info about the types of repeats you have for your events with regards to the records on database. You may have several daily repeats for one event and here the configurations, changes, and edits to the event are all influential.
    Repeats that are from before and update gradually create lots of data and might cause this kind of problem on the database.
    However, you don’t need to worry, you need to follow this on the latest version:

    1. Get a back of the database.
    2. Clear the records on mec-date table from database.
    3. go to the backend page of each event in WP and update your events one by one. these data will be set on the database again.

    Best Regards

    • This reply was modified 4 years, 4 months ago by webnus.

    Don Gordon (@rippledon)

    I just looked at my database and see something similar, we only have one event that recurrs once a week until january 2021. and there are over 1103 db entries for it.

    It’s only eating up 8k in my DB at the moment, but now I am feaful it will grow exponentailly as we add more or extend the date range of this event.

    Did the update work for you to resolve this?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Recurring events, Is this a joke?’ is closed to new replies.

Tags