mherger wrote: > Could you try to run that query against your library.db file using some > > SQLite client (command line or SQLite Manager extension in firefox)? > > > ... > > SELECT albums.discc AS 'albums.discc', contributors.name AS > 'contributors.name', contributors.namesort AS 'contributors.namesort', > albums.disc AS 'albums.disc', albums.titlesort AS 'albums.titlesort', > albums.titlesearch AS 'albums.titlesearch', albums.contributor AS > 'albums.contributor', albums.id AS 'albums.id', albums.title AS > 'albums.title', albums.artwork AS 'albums.artwork', albums.compilation > AS 'albums.compilation', albums.year AS 'albums.year' FROM albums JOIN > contributor_album ON contributor_album.album = albums.id JOIN > contributors ON contributors.id = contributor_album.contributor JOIN > tracks ON tracks.album = albums.id JOIN library_track ON > library_track.track = tracks.id WHERE contributor_album.role IN (5,1) > and library_track.library = "2da2d7ab" group by albums.id order by > contributors.namesort,albums.year, albums.titlesort limit 10; > > Get a list of library IDs: > > SELECT library FROM library_tracks GROUP BY library; > > -- > > Michael
Took 2s in my Dual Core XP 3.01 GHz, 4GB (limited to 3 by XP). Library: 58K tracks, 4K Albums, 9K Artists. SubLibrary: 30K tracks, 2K Albums, 3K Artists. Marco ____________________________________________________________ SB+, Klimo Merlino + Kent Gold, Monitor Audio Studio 20 Gold SE+, Klimo reference and DIS Interconnect. ------------------------------------------------------------------------ marcoc1712's Profile: http://forums.slimdevices.com/member.php?userid=34842 View this thread: http://forums.slimdevices.com/showthread.php?t=101701 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
