[WiP] Centralised database in My Video, My Pictures and folder settings (1 Viewer)

ajs

Development Group
  • Team MediaPortal
  • February 29, 2008
    13,582
    8,120
    Kyiv
    Ukraine Ukraine
    Country flag
    How many files are in the folder where you see the differencing?
    Cartoons folder ~200-250
    Movies folder ~300-350
     

    ajs

    Development Group
  • Team MediaPortal
  • February 29, 2008
    13,582
    8,120
    Kyiv
    Ukraine Ukraine
    Country flag

    regeszter

    Retired Team Member
  • Premium Supporter
  • October 29, 2005
    5,335
    4,954
    Hungary Hungary
    How many seconds needs to show the folder?
    Local database ~1-5s
    MySQL databse ~3-15s

    Is it a local folder?
    No. Network share (Windows Home Server 2011)

    Did you move the thumbnails from local machine?
    No. If transfer directory of thumbnails, to the server (hardlink, so work on my computer 3) the speed of opening the folder is almost unchanged.

    I do check on the test computer.
    Where is the mysql server? On WSH or locally?
     

    regeszter

    Retired Team Member
  • Premium Supporter
  • October 29, 2005
    5,335
    4,954
    Hungary Hungary
    I will test it with 300 files in one folder.
     
    Last edited:

    regeszter

    Retired Team Member
  • Premium Supporter
  • October 29, 2005
    5,335
    4,954
    Hungary Hungary
    I added 350 files to a network folder and added some statistics rows to my dev build.

    Here is my test result:

    MySQL on remote: GUIVideoFiles:LoadDirectory is finished in 6060 ms
    MySQL on local: GUIVideoFiles:LoadDirectory is finished in 2561 ms
    SQLlite on remote share: GUIVideoFiles:LoadDirectory is finished in 2303 ms
    SQLite on local: GUIVideoFiles:LoadDirectory is finished in 1302 ms

    It means the MySQL is slower then SQLite but the big difference if the database is in remote.
     

    ajs

    Development Group
  • Team MediaPortal
  • February 29, 2008
    13,582
    8,120
    Kyiv
    Ukraine Ukraine
    Country flag
    It means the MySQL is slower then SQLite but the big difference if the database is in remote.
    Why Kodi no such difference? Well, the local MySQL think very few people interesting. And it is strange that such a big difference in the local MuSKL and remote MySQL.
     

    Lehmden

    Retired Team Member
  • Premium Supporter
  • December 17, 2010
    12,316
    3,781
    Lehmden
    Germany Germany
    Country flag
    Hi.
    It means the MySQL is slower then SQLite
    We have encounter the same while developing SQLite DB plugin for MP2 server, so no big surprise. If you optimize SQLite for speed the difference even gets bigger (up to a factor of 4 means SQLite is four times as fast as MySQL when used as DB backend for MP2 server). So for MP2 there is an easy choice... But in this use-case you need to think about multiple write access at the same time, something SQLite did not like that much. MP2 server is handling all access to the DB, so no issue there, but in MP1 case you can not prevent simultaneous write access in all circumstances.

    Why Kodi no such difference?
    There also is a difference and this may be the reason why the centralized MySQL DB is no part of the regular Kodi release...
    Due to the proper .nfo support a centralized DB is not that important for Kodi than it is for MP. Simply hit "save DB" in GUI and all metadata incl. watched status is saved near to the media. Every client now can access this (and normally did this during startup) so a sync is done semi- automatically once per run...
     

    ajs

    Development Group
  • Team MediaPortal
  • February 29, 2008
    13,582
    8,120
    Kyiv
    Ukraine Ukraine
    Country flag
    There also is a difference and this may be the reason why the centralized MySQL DB is no part of the regular Kodi release...
    As no part? Added 3 lines in the configuration file and everything works out of the box.
    Just not everyone is necessary, and Kodi is more adapted to the type of work: put the USB stick and see.

    Due to the proper .nfo support a centralized DB is not that important for Kodi than it is for MP
    I transferred the the database from MP in Kodi . Unload all NFO, and start the update library on Kodi .
     

    Users who are viewing this thread

    Similar threads
    OP Title Forum Replies Date
    joEhSuper 5061: Music Database doesn't show all Data... 1.24-1.27 Pre Release 154
    toricred Using TMM, How to Stop Importer From Going to The Movie Database for Data General 1
    H MP2 database won't keep in synch with recordings General 8
    F How to reset tv recordings database General 5
    A Synchronizing client databases MediaPortal 1 Talk 10
    R Problems accessing MySQL database remotely MediaPortal 1 Talk 0
    globaldonkey Music Database Error Listen Music 1
    R [solved] Files moved to new location - Easy way to update database? My TVSeries 7
    R Files moved to different location - Easy way to update database? Moving Pictures 2
    H [solved] Video database genres, sort titles and collection thumbnails Newcomers Forum 12
    G MP1 TV Server "failed to upgrade the database" using MS Sql Server Installation, configuration support 3
    D PC rebuild & MP2 upgrade - how to preserve database and settings? General 1
    H MP1.21F video database scan, can it be scheduled to automatically run in background General Support 5
    D Large xml database in My Movies Management. I remain unclear on use My Films as bridge to MP2.2 General 9
    ajs Sync databases by Media Sync Service MediaPortal 1 Talk 26
    J Database schema General 0
    raffe Trailers via Youtube in Online Videos (for movies and maybe also TV-series) Feature Requests 0
    raffe [solved] [Solved] How to import TV series Videos Not in any online source? General 8
    A [solved] Video playback only successful after second attempt when returning from standby General Support 5
    bta489 Sometimes no image rendered when playing video watch/edit Videos 35
    S External player in MP2 and see videos made with my cam? General 8
    S Be able to see photos and videos together MediaPortal 1 Skins 1
    catavolt [solved] LMH - Wrong Video order Fanart Handler 27
    ajs [WiP] 5058: BlackScreen instead XMas Video :) MediaPortal 1 302
    rainbowforest MP2 - V2.3 Anmeldung Online Video (Streaming provider) Allgemeines Support- und Diskussionsforum 9

    Similar threads

    Top Bottom