I've been playing with this and trying to time it, but get very inconsistent results. With all genres selected, the initial list populates in under a second, which is as expected. But I'm seeing anything from 5 seconds to as long as 45 when a subset is chosen. Typically, it's about 12-18 seconds. I have about 40k tracks and 38 genres in the library.
Repopulating the list doesn't seem to take long at all, either adding that one song after one has played, or if I jump to the last song and force it to add 10 new songs (using the default setting) it seems pretty quick. I haven't examined the SQL, but if it is using IN (set) then I just realized that WHERE genre IN (1,6,7,8) AND genre NOT IN (2,3,4,5,9,10) would be equivalent to simply WHERE genre NOT IN (2,3,4,5,9,10) Maybe that would be faster. ------------------------------------------------------------------------ JJZolx's Profile: http://forums.slimdevices.com/member.php?userid=10 View this thread: http://forums.slimdevices.com/showthread.php?t=100327 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
