Loading music database (on startup) takes very long (1 Viewer)

Dragy

Portal Pro
April 27, 2009
778
333
31
Home Country
Netherlands Netherlands
I was investigating the startup of MediaPortal and found out that namely the loading of the music database takes a long time, 10 seconds! Also the ChannelNavigator thing takes pretty long:
Code:
2013-03-21 16:14:45.865234 [Debug][CacheChannels(13)]: CacheChannelsThread: started
2013-03-21 16:14:46.009765 [Info.][CacheChannels(13)]: ChannelNavigator::LoadSettings()
2013-03-21 16:14:48.193359 [Warn.][Extension Settings(14)]: GUIWindow:OnWindowLoaded: 'C:\ProgramData\Team MediaPortal\MediaPortal\Skin\Titan\myextensions2settings.xml' is missing control id 3 (window property: btnDefaults)
2013-03-21 16:14:48.348632 [Debug][CacheChannels(13)]: CacheChannelsThread: ended
2013-03-21 16:14:49.232421 [Debug][MPMain(1)]: MusicDatabase: GetSongsByFilter - SQL: select distinct strAlbumArtist, strAlbum, dateAdded, strGenre, strPath from tracks order by dateLastPlayed desc limit 50;, Filter: tracks
2013-03-21 16:14:58.307617 [Info.][MPMain(1)]: SQLiteClient: Closing database: PictureDatabase.db3
2013-03-21 16:14:59.588867 [Info.][MPMain(1)]: [MP Upnp Renderer:] Started Plugin with Assembly-Version: 2.2.0.3

Any way to speed this up? The music database is a little more then 10MB. I'm not planning to remove some music.
I'm using a Kingston V+ 200 SSD

Logs: https://forum.team-mediaportal.com/...d-mediaportallogs_21_03_13__15_50-zip.124455/

edit:
Must be a plugin that loads the database, because in debug mode to report to Team MP, it doesn't do this.
 
Last edited:

Dragy

Portal Pro
April 27, 2009
778
333
31
Home Country
Netherlands Netherlands
It's the LatestMediaHandler plugin with the latest music option enabled..
 
Last edited:

tourettes

Retired Team Member
  • Premium Supporter
  • January 7, 2005
    17,301
    4,800
    Basicly plugins shouldn't do anything when they are started. All the long work should be done in a worker thread(s).
     

    ltfearme

    Community Plugin Dev
  • Premium Supporter
  • June 10, 2007
    6,751
    7,196
    Sydney
    Home Country
    Australia Australia
    I would also be concerned on why that query takes so long. 10secs to execute that query seems too long.
     

    Users who are viewing this thread

    Top Bottom