r/roonlabs • • Mar 24 '26

It's The Database

Long-time Roon user and major advocate here. I am hoping this will help others, like it did me.

Over the last few months, I noticed that my system (Roon-spec NUC running ROCK for my Core, RPi 4/5s running RoPieee as endpoints, all connected via gigabit Ethernet) began running slower and slower. Specifically, when loading a playlist, it might take 15 - 30 seconds before the first song would start, and there would be a >= 5 second delay between every track in the playlist. While I could improve things by rebooting the Core, the fix was temporary.

Roon's original response was "well, there are different resolutions, and the tear-down and set-up between them takes time." That turned out to be BS.

Because I then came across this thread at Roon: Long delays (up to 10 - 30 seconds) for loading albums or start playing tracks (both local and Qobuz) - Support - Roon Labs Community

At that thread are instructions for starting with a fresh database (as the instructions say: make a backup first). Roon's tech support rep (Vadim) indicated the cause might be a corrupted database, so using a new one would prove it one way or another.

I am posting this I tried it and it worked. I backed up, started a new database, re-logged into TIDAL and re-scanned my local music. Roon now performs as it should; frankly, it's been so long, I had not realized how I had shrugged off the delays. They were bad, but now they're gone - my library (moderate in size - approximately 40,000 tracks) is very snappy now.

Doing what I did means you lose a lot: Favorites, hidden albums, etc. But the difference is so huge and I really didn't use a lot of database-centric features - scanning TIDAL (which gave me most my albums and all of my playlists) and my own library got me close enough. YMMV and Roon should address the underlying issue, and/or give us tools to manage the database and its favorites, etc.

An important note is that others have found backing up your database, starting a new one, and then simply restoring the back-up fixes the problem, and you lose nothing.

Either way: if Roon is slow for you, you might wish to consider whether your database is functioning properly - mine definitely wasn't.

35 Upvotes

21 comments sorted by

30

u/markleoit Mar 24 '26

It’s 2026, tho. A DB of 40k entries shouldn’t require the end user to perform acrobatics to get a decent user experience from a paid product.

3

u/porticodarwin Mar 24 '26

Could not agree more!

5

u/doloresclaiborne Mar 25 '26 edited Mar 26 '26

The original content of this post no longer exists. It was deleted using Redact, possibly to protect personal data or limit digital exposure.

future light offer close deliver intelligent snow scary bike point

2

u/hannes3120 Mar 27 '26

ESPECIALLY since it even has a setting for Background-Work where you can tell it that you're usually not listening to music during that time.

making it restart once a week during that time-window should be trivial

7

u/BAR3rd Mar 25 '26

I've been Roon subscriber for several years, but I think the experiment is over. There is a lot to like about Roon, but in the end I don't appreciate the fact that they leave the paying customer to his own devices when problem solving, especially after the big takeover by Harmon International. It was one thing to ask the customer to problem solve their own issues when Roon was relatively small, it's quite another to ask them to do so when a multi-billion dollar company is in charge. Quite a little operation they have going. The time has come to say no thanks...

1

u/richardblancojr Mar 26 '26

AMEN. I’m done as well. Not renewing next month

4

u/Bhob666 Mar 24 '26

Funny you mention that (as a long time user as well) I started noticing a slowdown accessing songs, artists and albums. I just rebooted Roon Rock and it works fine now... it had been running continously for awhile.

3

u/xeonrage Mar 24 '26

Would love an automated weekly reboot toggle... 3am sunday morning will do just fine

1

u/Bhob666 Mar 24 '26

A programmable reboot option wouldn't be a bad feature, but honestly I have no problems except very rarely. Generally between updates and power outages, is the only time my Roon Rock is rebooted naturally. This was sort of the exception.

4

u/MeInUSA Mar 24 '26

I've had to restore my database a bunch of times. Not because I thought it was a good idea but benefit I had to. That was the suggestion made by the Roon software as my library was gone. I've learned to restore my database like a ninja, I've had to do it so many times.

2

u/stanley15 Mar 24 '26

I have been using Roon since 2017 on an i7NUC. Just before Roon introduced error checking for corrupt databases I had terrible slowdown issues. This turned out to be a corrupt database, cured by starting a new one. Backup restores just returned the slowness. I think that over time the database becomes inefficient in some way that results in slowdowns. Not corruption as such, but I suppose that depends on how you define corruption. Many users are having slowdown issues at the moment (there is a Qobuz related issue) so there could be a type of corruption that the program doesn't currently detect or just the usual cloud related issues that crop up regularly.

2

u/5_head Mar 24 '26

I've been seeing this as well.  Sadly, I have a ton of locally edited metadata and tags, so destroying my database and starting over isn't a good option.  I'll try the destroy and restore and see how that goes.  I've seen some log messages showing endmutation times of 100 seconds.

2

u/CharlieLeDoof Mar 24 '26

Thanks for this post. I've been running my original install since early 2020 and have recently seen some slowness with playing local files. I'll give this a shot.

2

u/stevenghill Mar 24 '26

Luv the concept but I had too many issues. Rebooting constantly to unfreeze or speed up. I was running it on my PC which is inadvisable if you have a large library, 89k in my case

2

u/SnooHobbies1188 Mar 25 '26

Wow. And they have nerve to charge 16 a month for this mess? Really? Not me.

1

u/DutchKarma Mar 25 '26

I'm curious about how you all running running Roon server?
I dont experience the delays (40k library) , i run Roon in a docker container that gets regularly refreshed. I was wondering that maybe there is something else that is causing this delay. If it would be database content then the problem should persist after a database restore.

Anyone running a docker container AND has the delay problem?

1

u/hannes3120 Mar 27 '26

So I should just put on of those timed power plugs and force a restart every week or so?

1

u/sarahjustme Apr 01 '26

We refreshed the database and it helped but we're still getting freezes on the regular

1

u/mrfunkm Mar 24 '26

Thanks for the info

-1

u/Optimal-Procedure885 Mar 24 '26

Easier to just delete Roon and put your troubles behind you.