Okay
  Public Ticket #3240143
Tons of events stored in database slows website down
Closed

Comments

  •  1
    Susann started the conversation

    Hi,

    I make use of the option to make events recurring. I have approximatly 20 events that recure every week through the whole year. I noticed that every recurrence of an event gets stored as a new entry in the database. Of course this generates a lot of entries in my database wich slows down the website immensly. Do you have a tool to remove expired event posts from the database? I cannot remove them manually each time. Also it woud be favourable if you could change the way recurring events get posted to the database and to only make one entry ein the db for every recurring event.

    kind regards,
    Susann

  •  2,572
    Aleksandar replied

    Hello Susann.

    Thank you for reaching out to us.

    This is how recurring events are handled - as separate events. Please check out this article about the difference between recurring and multi-day events.

    At the moment, there's no way to bulk-delete events in any way other than manually (canceling the events first, and then deleting them), but our developers are working on that, so hopefully, you'll be able to delete past events with more ease soon.

    The events are not that heavy for the database, though, as 1 event is approximately 3 - 5KB, so it would take around 200 - 300 events to build 1MB of data in your database.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables