[beeswax]

Regarding slow library loading, #920 is even worse than #912 and above.

php:
18:47:57.656 T:140255142619264   DEBUG: CGUIMediaWindow::GetDirectory (special://profile/playlists/video/GrownupsTV.xsp)

18:47:57.656 T:140255142619264   DEBUG:   ParentPath = [special://profile/playlists/video/GrownupsTV.xsp]

18:47:57.709 T:140255142619264   DEBUG: This query part contains a like, we will double backslash in the next field:  LIKE '

18:48:00.475 T:140255142619264   DEBUG: RunQuery took 2763 ms for 717 items query: SELECT * FROM tvshow_view  WHERE (( NOT  EXISTS (SELECT 1 FROM genre_link         JOIN genre ON genre.genre_id=genre_link.genre_id         WHERE genre_link.media_id=tvshow_view.idShow AND genre.name  LIKE 'Children' AND genre_link.media_type = 'tvshow')))

18:48:27.672 T:140254991509248   DEBUG: Thread JobWorker 140254991509248 terminating (autodelete)

18:48:27.672 T:140254658361088   DEBUG: Thread JobWorker 140254658361088 terminating (autodelete)

18:48:27.673 T:140254649968384   DEBUG: Thread JobWorker 140254649968384 terminating (autodelete)

18:48:27.673 T:140253465655040   DEBUG: Thread JobWorker 140253465655040 terminating (autodelete)

18:49:56.763 T:140253960595200   DEBUG: script.grab.fanart: found 781 tv files

18:49:56.823 T:140253960595200   DEBUG: GetArtistsByWhereJSON query: SELECT a1.*, art.art_id AS idArt, art.type AS artType, art.url AS artURL FROM (SELECT artist.idArtist, strArtist, strBiography FROM artist  WHERE ((EXISTS (SELECT 1 FROM song_artist WHERE song_artist.idArtist = artist.idArtist AND song_artist.idRole = 1) OR EXISTS (SELECT 1 FROM album_artist WHERE album_artist.idArtist = artist.idArtist)) AND (artist.strArtist != '')) AND (artist.strArtist <> 'Various artists') ORDER BY artist.idArtist) AS a1 LEFT JOIN art ON art.media_id = a1.idArtist AND art.media_type = 'artist' WHERE art.type = 'fanart' GROUP BY a1.idArtist, art.art_id ORDER BY a1.idArtist, arttype

18:49:56.834 T:140253960595200   DEBUG: GetArtistsByWhereJSON - query took 12 ms

18:49:56.836 T:140253960595200   DEBUG: script.grab.fanart: found 0 music files

18:50:12.206 T:140255142619264   DEBUG: Saving fileitems [special://profile/playlists/video/GrownupsTV.xsp]

18:50:12.216 T:140255142619264   DEBUG:   -- items: 717, sort method: 0, ascending: true

Over 2 minutes now, compared to 30-60s on #912+ and only 2-3s on #911

Full debug log here