mherger wrote:
> Is this about right?
>
Yes.
>
> Confirmed: I can't play "Pippi Langstrumpf in Taka Tuka Land", but I can
>
> play all its tracks from the kids' menu. Correct?
>
Again: yes.
>
> Hmm... I'm not sure I fully understand the issue, can't reproduce it.
> I've enabled the "no kids music" library as the default view. Then I
> browse Artists -> All Albums. Takes about two seconds in the web UI,
> less than a second in iPeng. I tried both, the unified list as well as
> the separate Album Artist/All Artists lists.
> ...
> Can you check the resources to figure out whether it's memory, disk IO
> or CPU bound?
Artists->All Albums is fast for me, too, it's "Album Artists->All
Artists" that is slow.
It's CPU (one core maxed out for the whole time of the query). All other
figures are low (176 MB RAM, very little disc IO to my flash drive...)
Subsequent queries of the same page are much, much faster and consume
less CPU although still slower than "Artists->All Albums", it seems to
be primarily the first load after selecting the filtered library (in
"Library Views") that is so extremely slow (stays slow until I have
completely loaded the list at least once). So to reproduce it you might
have to switch your libraries.
BTW, after switching libraries "Album Artists->All Albums" is slow even
with the unfiltered library, albeit not as extreme as for the filtered
one.
The query is
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]
--------------------
This seems to be the "Album Artists" query, which is not as slow:
Code:
--------------------
[15-01-13 13:18:13.4218] Slim::Control::Queries::artistsQuery (1130) Artists
query: SELECT contributors.id, contributors.name, contributors.namesort FROM
contributors JOIN contributor_album ON contributor_album.contributor =
contributors.id WHERE
contributors.id IN (
SELECT DISTINCT
contributor_track.contributor
FROM contributor_track
WHERE (contributor_track.role IN
(5,1,4,2,3,6) ) AND contributor_track.track IN (
SELECT library_track.track
FROM library_track
WHERE library_track.library = ?
)
)
GROUP BY contributors.id ORDER BY
contributors.namesort COLLATE en_US LIMIT ?,? / ["9e75b8cb", 6600, 500]
--------------------
There's also the occasional one of these in there:
Code:
--------------------
[15-01-13 13:21:38.7187] Slim::Schema::Debug::query_start (23) SELECT me.id,
me.type, me.name, me.active, me.total, me.done, me.start, me.finish, me.info
FROM progress me WHERE ( type = ? ) ORDER BY start,id: 'importer'
--------------------
don't think they are related, though.
"My Music" settings:
17148
+-------------------------------------------------------------------+
|Filename: settings.png |
|Download: http://forums.slimdevices.com/attachment.php?attachmentid=17148|
+-------------------------------------------------------------------+
---
learn more about iPeng, the iPhone and iPad remote for the Squeezebox
and
Logitech UE Smart Radio as well as iPeng Party, the free Party-App,
at penguinlovesmusic.com
*New: iPeng 8, the Universal App for iOS 7 and iOS 8*
------------------------------------------------------------------------
pippin's Profile: http://forums.slimdevices.com/member.php?userid=13777
View this thread: http://forums.slimdevices.com/showthread.php?t=101701
_______________________________________________
beta mailing list
beta@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/beta
