investigating Remove Hidden Songs

My DB is now over 400GB and the one thing I would like to do, I do not thing there is a graceful way to do it.

I have free accounts and subscriptions. If a subscriber cancels after a year and he had 100 songs and goes to a free account which displays 5 songs, I still have 95 songs hidden. I get keeping these around for 2-3 months in case the user wants the subscription back and all songs/reviews to display. However if several months go by, let alone years, this is just eating hard drive space.

Is there a way to remove these hidden songs, reviews etc,?
updated by @dazed: 03/09/20 07:43:35AM

Sorry for the delay responding here.
There is no inbuilt way of doing this so something custom would be needed. The main issue with this deciding which songs to keep (most recent, most played, whatever). You'd then need to enter how many to keep, though this could be based on their quota settings. The same would apply to any othe items that are limited by quota, blogs say - keep most recent, keep those with most comments?
The upshot is a module that could end up being fairly complex.
hth


--
Paul Asher - JR Developer and System Import Specialist

Hey Paul! No worries on the delay. This functionality should really already exist. It makes no sense that we would allow quotas with a potential higher quantity of songs, videos, images etc. and then when the subscription is cancelled, we have no way to eliminate the extra data after months to years of inactivity. For new sites this would not be an issue. For sites that have been around for almost 15 years it creates a bit of a problem lol.

My dashboard states: 400.74GB of 984.64GB. This is a huge amount of data being stored. I question where all of the data is from though. There are over 18k songs. Videos should all be youtube which leaves images. Hopefully I do not have some large error logs around.
updated by @dazed: 12/01/19 12:09:07PM

Investigating whether a module to do this is easily doable.


--
Paul Asher - JR Developer and System Import Specialist

Thanks Paul. Appreciate the help as always.