You can try the workaround described below or anything similar.
I don’t think it will completely solve your problem, but I think it will improve the situation.
I have a local library of a little over 25,000 tracks, with files organized like this: artist folder / album folder / tracks.
I used this convention for the name of the track files: DD-NN track_name. DD is the disc number (if applicable) and NN is the track number.
I saw that the path and file name are stored in the Roon database, so I wanted to see the impact of reducing the length of the file name. I removed track_name from the file name and left only DD-NN.
After that, the duration of the …