search

weannounce / arrnounced

Notify Sonarr/Radarr/Lidarr of tracker IRC announcements.
22 stars 3 forks source link

Database reduction #22

Closed GregTroar closed 2 years ago

GregTroar commented 3 years ago

Hi,

Is there a way to reduce the size of the db, in a few months I have snatched around 900,000 releases and db is growing fast. Any chance to implement an option to keep only xx days in the db ?

I manually deleted in the db as i think there is no other option for now ?

Thanks

weannounce commented 3 years ago

You are correct, there is no such functionality at the moment. I want to add it but I have not come up with a good solution for it yet.

It should preferably be something automatic. Perhaps a separate thread, doing maintenance, which triggers once a day or so. Checking for entries that are too old for every received release seems like a waste. Doing it manually in the web UI could be a good complement, but I don't like it as the only way of cleaning old entries.

I'll see what I can do.

weannounce commented 2 years ago

Discarding announcements older than X days is now possible. The functionality was added in 0.8.0, but there was a performance update to it in 0.8.1.

It will by default purge anything older than 365 days. This value can be changed in the config.

Sorry for the delay in implementing this, I hope it satisfies your needs.

GregTroar commented 2 years ago

Hi thanks for this. I am not using arrnounced anymore as I moved to another project which cover the same needs as what arrnounced is doing