auto-playlists takes forever to load sometimes
Posted: Fri Jun 17, 2011 5:09 am
Hi,
Sometimes it takes forever for an autoplaylist to open. I attached to debug log snippets during these occasions:
00000558 85.25052643 [6176] Thread initialized 4800
00000559 85.25466919 [6176] 4800 DB open SQL: SELECT Songs.*
00000560 85.25466919 [6176] FROM Songs WHERE (Songs.SongPath like '%cd-compilations%')
00000561 85.49829102 [6176] 4532 DB open SQL: SELECT Playlists.*, (SELECT Count(*) FROM Playlists as Plst2 WHERE Plst2.ParentPlaylist=Playlists.IDPlaylist) AS cnt FROM Playlists WHERE Playlists.ParentPlaylist=3631 ORDER BY Playlists.PlaylistName
00000562 139.98991394 [6176] 4800 DB lock finished, took 192447028.
00000563 140.00610352 [6176] 4532 DB lock finished, took 191640930.
00000564 140.46220398 [6176] Thread has started 7968
00000565 140.46228027 [6176] Thread registered, going to initialize 7968
another huge "took" number here: (which I think has something to do with the time it took?)
00000000 0.00000000 [4788] Thread has started 3640
00000001 0.00014022 [4788] Thread initialized 3640
00000002 0.07402924 [4788] Going to make final callback 3640
00000003 30.00225258 [4788] Thread has started 460
00000004 30.00238228 [4788] Thread initialized 460
00000005 30.07626534 [4788] Going to make final callback 460
00000006 60.00486755 [4788] Thread has started 5372
00000007 60.00506592 [4788] Thread initialized 5372
00000008 60.08601761 [4788] Going to make final callback 5372
00000009 90.00671387 [4788] Thread registered, going to initialize 2484
00000010 90.07696533 [4788] Going to make final callback 2484
00000011 110.25587463 [4788] Going to execute format plug-in destructor.
00000012 110.25630188 [4788] 4792 DB lock successful.
00000013 121.03912354 [4788] 3628 DB lock finished, took 710908060.
00000014 121.04119110 [4788] 4792 DB exec SQL: UPDATE Songs SET PlayCounter=1,LastTimePlayed=40711.499383148, TrackModified=40711.499383148, PlaybackPos = 0 WHERE Id=487464
00000015 121.04238129 [4788] 4792 DB lock finished, took 3831.
00000016 121.04371643 [4788] Player: Next command started
I do have a huge database, but sometimes it takes over a minute! And this on my up to date workstation with brand new HD, not an old notebook..
cheers,
Bernhard
Sometimes it takes forever for an autoplaylist to open. I attached to debug log snippets during these occasions:
00000558 85.25052643 [6176] Thread initialized 4800
00000559 85.25466919 [6176] 4800 DB open SQL: SELECT Songs.*
00000560 85.25466919 [6176] FROM Songs WHERE (Songs.SongPath like '%cd-compilations%')
00000561 85.49829102 [6176] 4532 DB open SQL: SELECT Playlists.*, (SELECT Count(*) FROM Playlists as Plst2 WHERE Plst2.ParentPlaylist=Playlists.IDPlaylist) AS cnt FROM Playlists WHERE Playlists.ParentPlaylist=3631 ORDER BY Playlists.PlaylistName
00000562 139.98991394 [6176] 4800 DB lock finished, took 192447028.
00000563 140.00610352 [6176] 4532 DB lock finished, took 191640930.
00000564 140.46220398 [6176] Thread has started 7968
00000565 140.46228027 [6176] Thread registered, going to initialize 7968
another huge "took" number here: (which I think has something to do with the time it took?)
00000000 0.00000000 [4788] Thread has started 3640
00000001 0.00014022 [4788] Thread initialized 3640
00000002 0.07402924 [4788] Going to make final callback 3640
00000003 30.00225258 [4788] Thread has started 460
00000004 30.00238228 [4788] Thread initialized 460
00000005 30.07626534 [4788] Going to make final callback 460
00000006 60.00486755 [4788] Thread has started 5372
00000007 60.00506592 [4788] Thread initialized 5372
00000008 60.08601761 [4788] Going to make final callback 5372
00000009 90.00671387 [4788] Thread registered, going to initialize 2484
00000010 90.07696533 [4788] Going to make final callback 2484
00000011 110.25587463 [4788] Going to execute format plug-in destructor.
00000012 110.25630188 [4788] 4792 DB lock successful.
00000013 121.03912354 [4788] 3628 DB lock finished, took 710908060.
00000014 121.04119110 [4788] 4792 DB exec SQL: UPDATE Songs SET PlayCounter=1,LastTimePlayed=40711.499383148, TrackModified=40711.499383148, PlaybackPos = 0 WHERE Id=487464
00000015 121.04238129 [4788] 4792 DB lock finished, took 3831.
00000016 121.04371643 [4788] Player: Next command started
I do have a huge database, but sometimes it takes over a minute! And this on my up to date workstation with brand new HD, not an old notebook..
cheers,
Bernhard