Could you try to run that query against your library.db file using some
SQLite client (command line or SQLite Manager extension in firefox)?
Code:
--------------------
[15-01-13 13:20:14.0735] Slim::Control::Queries::albumsQuery (671) Albums query:
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 (?, ?) AND
library_track.library = ? GROUP BY albums.id ORDER BY contributors.namesort COLLATE en_US
, albums.year, albums.titlesort COLLATE en_US LIMIT ?,? / [5, 1, "9e75b8cb",
10
0, 100]
Just replace the ? placeholders with the parameters listed at the end.
And you'll probably have to remove the COLLATE en_US, too. Takes a
fraction of a second to execute on my Atom based server, with a
sub-library of about 17k tracks.
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
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta
