Just in case anyone else with a ginormous collection is interested in creating a sub 100K, genre-based library view, SQLite Expert Personal is a very useful query tool:
http://www.sqliteexpert.com/download.html Just make a copy of library.db and open it in SQLite Expert. This query will give you a list of the number of FLAC tracks for each genre (leave out the "tr.content_type = 'flc' and " part for all file types or use your preferred type): select g.namesort, count(tr.id) from tracks tr, genres g, genre_track gt where tr.content_type = 'flc' and tr.id = gt.track and g.id = gt.genre group by g.namesort order by g.namesort You can then copy and paste the results into a spreadsheet and play with combinations of genres until you have the one that works best for you. My spreadsheet has the genre in column a, the count in column b, column c is blank and this formula entered into the first row of data (starting on row 6) in column d: =if(c6>" ",b6,0) and copied to all the subsequent rows. I freeze the top row so it doesn't scroll and enter this formula into B1: =sum(D6:D150) Then I can put an "x" in column c to select genres and get the total of my selections at the top of the sheet. Win7Pro(x64)[3.3Ghz i5, 8GB RAM, 120GB SSD system, 15TB storage], LMS 7.9.0 -> Logitech Squeezebox Classic V.3 -> Cambridge Audio DacMagic -> NAD C160 -> 2 x NAD C272 -> Quad 22L2 ------------------------------------------------------------------------ get.amped's Profile: http://forums.slimdevices.com/member.php?userid=10022 View this thread: http://forums.slimdevices.com/showthread.php?t=102910 _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/plugins
