Best Practices for Large Libraries…

I have over 700,000 track in my Roon library, when Roon is working well having a large library like this is fantastic using Roon’s music discovery attributes.

Unfortunately my Nucleus+ with 32Gb Ram doesn’t provide a great Roon experience.
I have an internal 4TB SSD for some of my music files and the rest on an external drive.

I love the Roon software but slowdowns, sluggish performance and crashes makes using Roon very frustrating.

I tried switching the core to my to my Mac mini (2018) 3.2 GHz 6-core i7 and found Roon to be quite faster. As this is my main machine (apart from my 2015 MacBook Pro) I couldn’t use it solely for Roon.

I’m looking for an affordable alternative (say $500A) that won’t choke with my large library.
Does anyone have a similar sized library with a success story and suggestions?

Maybe a big noisy desktop hidden in a cupboard ? 700k tracks is a big library.

I used my i7 7700 desktop with 16 Gb for a long time with no issues, obviously there are bigger and better processors around and I would certainly go 32gb

The downside is the noise but if you can isolate it , mine was in the study nowhere near the listening room, its a good solution

@Rugby often has ideas on this subject.

Thanks Mike