I've committed another change to 7.9 which should greatly help
performance if you've got a largish library (five digits and more
tracks) and are using library views. This will cause a full rescan when
you update your server next time.
Background: previously there was only a library_track table. All other
queries (artists, albums, genres...) were then first querying a list of
tracks in order to build the final selection. With this could result in
really long query run times and lots of memory usage. Browsing 12k
artists in a 25k library took several seconds for the data query only.
Therefore I decided to de-normalize the library handling the same way we
did with the main database. I introduces library_contributor/album/genre
tables to considerably speed up those queries. These tables are built at
scan time. The overhead there is negligible compared to the overhead
caused at browse time.
Please give it a good test ride asap, as I'll be mostly out of SB land
for the next 2-3 weeks.
--
Michael
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta
