At least in my system, the RAM problem does not appear when scanning the library. After initializing / pronouncing Roon Server, the occupied RAM is small. It gradually grows as you listen to music / browse the application and has a boom when backing up the database.
Check this post: Memory leaks on QNAP - #17 by DanielAvasilichioaei