I, too, have done the fresh database procedure and I can confirm that it is a huge difference - Roon has not performed like this for me in a long time. BTW: I am running a Roon-spec NUC with ROCK, and everything is connected via gigabit Ethernet, on a new router and switch.
I must ask: this sure seems important. So shouldn’t there be something happening internally that would keep the database efficient and not “corrupt”?
But again, thank you @vadim for identifying this fix. Is there any way to recover favorites, etc.?