search

craftcms / webhooks

Plugin for integrating Craft with Zapier and IFTTT.
https://plugins.craftcms.com/webhooks
MIT License
84 stars 12 forks source link

Need some sort of auto-purge of logged requests #39

Closed jishi closed 3 years ago

jishi commented 3 years ago

Description

I have been running this plugin on Entry afterSave for two weeks, and it has already accumulated 67k rows which prevents me from backing up the database from the admin interface (and blocking access to the site).

Preferably some retention setting (1 day, 1 week) and purge all entries that are done and older automatically. Also with correct indexes to avoid a cleanup to choke the whole database server :)

mildlygeeky commented 3 years ago

Seconding this - I was surprised to see how quickly the size of a Craft DB had grown, and assumed it must have been Neo or something. Was shocked to see that around 1/3 of the size of my entire DB was just logged webhook requests!

Would be great if there were a config setting for number of days' worth of requests to log, with older ones being flushed out at GC or something.