Over the years, my collection has grown way past the recommended size. There’s a lot of crap there. From movie OSTs, to game OSTs, to random things I found left and right, to classic albums. Not everything is good obviously. I’d like to clean up.
Maybe find:
There are no track ratings in Roon, just album ratings. You can use Focus to show those with a low rating. E.g., go to Focus > Ratings, select ratings with 2+ stars, then click the tag so that it inverts and turns red. Then it will show only albums with 0 and 1 stars.
Go to My Library > Tracks and sort by length
Difficult so say not knowing your library. Focus (e.g. genres) may help.
Use multi-selection:
Find stuff you’ve never listened to in roon and delete a load of that. You can find it in focus.
Sure you can find and delete things but know there is no routine to actually reclaim the database space nor disk space consumed. The only way to truly clean the db is to start fresh unfortunately that involves the loss of all metadata (likes, loves, play count, etc.).
Disk space used for file storage is reclaimed by the OS. Are you saying that the Roon DB will just grow in size over time, despite deletions of music? Where did you read this?
Yes, the DB will just grow and grow. It’s been this way since the beginning…and unless the underlying DB has changed I believe this behavior is the same to this day.
I’ll see if I can find my posts when I asked about how to reduce the white space and link here.
Here Danny says the images are now stored outside of the DB. - Is it normal for Roon's database size/structure to be so large? [yes] - #65 by danny
Here’s my original query and subsequent feature request: DB size - images for deleted albums - #11 by Larry_Post
I can’t see in the linked thread that the database will only grow and grow, even when content in Roon is deleted, except for the images according to the second thread (which are now in Valence though). At least not in a statement by Roon - there is a user in the second thread claiming this
My 6+ years experience with Roon shows me that is only grows and grows. I’ve not paid attention to it for the past 2-3 years however. Originally I was running on Linux in RAM and it became a problem. I’ve since switched to Windows and it runs better for me and the db size is (so far) not an issue for my 16GB of RAM.
Currently, I have 107,106 tracks and the db folder size is 5.5GB. 14,053 files and 39,141 folders.
It has to grow and grow if stuff gets added though. When your delete stuff and do a library cleanup, does it stay the same size? I dunno, never deleted much.
Anyway, it seems to me that the OP wants to remove unused stuff that clutters up what he sees in the library. Not sure they are concerned about the DB size
Years ago I inadvertently added my music storage locations in duplicate so Roon ingested it all again. The DB doubled in size. I removed the duplicate locations, ran clean up and the size didn’t change hence my original question to support regarding white space reclamation.
I started a new DB from scratch to recover from that incident as the DB was too large to fit into RAM I had at the time running ArchLinux completely from RAM.
Perhaps things are improved since Valance changed the handling of images but I’m not willing to experiment at this point. 
Agreed, the OP appears to just be looking for a way to identify what he wants to ‘remove’ from view with no apparent concern or knowledge of the underlying impact to the DB.
Thanks for the info
Somehow similar… but different.
I have some online albums added to my libery from Qobuzz which are no longer available in Qobuzz or which have been replaced by another online version.
Is there a way to figure out these dead links?
Thx
Knud
I believe there (partially) is, but I cannot test it right now as I have (most probably) no unavailable Qobuz albums in My Library.
A couple of weeks ago unavailable Qobuz showed up under Channel Layout in focus.
Maybe it still does but it has been reported by one of the moderators that this is (will be ?) removed.
(can’t remember/find the topic right now)
This was (is?) due to the fact that Qobuz albums have now a proprieraty format called Qobuz (only God and Danny know why).
I have used this to cleanup unavailable Qobuz albums.
A second way to achieve this (but again I don’t know for sure as I cannot test this, is to use Focus on Storage Location - Qobuz library + unidentified albums (select Inspector - Identified and then reverse by clicking on it so it becomes red)
In my opinion all Qobuz albums should be identified, unless they are not available anymore.
I don’t know for sure if this really works and if it would find all unavailable albums, but you can give it a try. Does not take long and does nothing wrong.
Dirk
Hi Dirk,
many thanks. Your first option does work. Now I have to re-add 120 albums.
BR
Knud
Thanks Dirk
I have just checked and selecting Channel Layout then Other shows unavailable Qobuz tracks.
There are generally other versions available although these aren’t always exactly the same i.e. different numbers of tracks.
yes, for what ever reason some albums have been replaced by a different version…
I was able to sort these albums out and replaced them with the actual available versions from Qobuzz.
BUT: this will not help for those tracks which you have added to a personal playlist. Any solution for this issue?
BR
Knud
Whatever you do, proceed with caution. I just mass deleted 6,000 duplicate music files thinking I was keeping the flac files and deleting the mp3 or aac etc files. Boy was I wrong. Well, good luck to you.
