[WiP] - Centralised database in My Video, My Pictures and folder settings | Page 7

Discussion in 'Area 51 - Testing Area' started by regeszter, February 6, 2015.

  1. ajs
    • Team MediaPortal

    ajs Development Group

    Joined:
    February 29, 2008
    Messages:
    8,829
    Likes Received:
    2,792
    Gender:
    Male
    Occupation:
    IT
    Location:
    Kyiv
    Ratings:
    +4,797 / 30
    Home Country:
    Ukraine Ukraine
    Show System Specs
    Cartoons folder ~200-250
    Movies folder ~300-350


     
  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. regeszter
    • Premium Supporter

    regeszter Retired Team Member

    Joined:
    October 29, 2005
    Messages:
    5,335
    Likes Received:
    2,863
    Ratings:
    +5,152 / 18
    Home Country:
    Hungary Hungary
    How many seconds needs to show the folder? Is it a local folder? Did you move the thumbnails from local machine?
     
  4. ajs
    • Team MediaPortal

    ajs Development Group

    Joined:
    February 29, 2008
    Messages:
    8,829
    Likes Received:
    2,792
    Gender:
    Male
    Occupation:
    IT
    Location:
    Kyiv
    Ratings:
    +4,797 / 30
    Home Country:
    Ukraine Ukraine
    Show System Specs
    Local database ~1-5s
    MySQL databse ~3-15s

    No. Network share (Windows Home Server 2011)

    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.
     
    • Thank You! Thank You! x 1
  5. regeszter
    • Premium Supporter

    regeszter Retired Team Member

    Joined:
    October 29, 2005
    Messages:
    5,335
    Likes Received:
    2,863
    Ratings:
    +5,152 / 18
    Home Country:
    Hungary Hungary
    Where is the mysql server? On WSH or locally?
     
  6. ajs
    • Team MediaPortal

    ajs Development Group

    Joined:
    February 29, 2008
    Messages:
    8,829
    Likes Received:
    2,792
    Gender:
    Male
    Occupation:
    IT
    Location:
    Kyiv
    Ratings:
    +4,797 / 30
    Home Country:
    Ukraine Ukraine
    Show System Specs
    On WHS :) Kodi uses it as well.
     
  7. regeszter
    • Premium Supporter

    regeszter Retired Team Member

    Joined:
    October 29, 2005
    Messages:
    5,335
    Likes Received:
    2,863
    Ratings:
    +5,152 / 18
    Home Country:
    Hungary Hungary
    I will test it with 300 files in one folder.
     
    Last edited: March 4, 2015
    • Like Like x 1
  8. regeszter
    • Premium Supporter

    regeszter Retired Team Member

    Joined:
    October 29, 2005
    Messages:
    5,335
    Likes Received:
    2,863
    Ratings:
    +5,152 / 18
    Home Country:
    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.
     
    • Like Like x 2
  9. ajs
    • Team MediaPortal

    ajs Development Group

    Joined:
    February 29, 2008
    Messages:
    8,829
    Likes Received:
    2,792
    Gender:
    Male
    Occupation:
    IT
    Location:
    Kyiv
    Ratings:
    +4,797 / 30
    Home Country:
    Ukraine Ukraine
    Show System Specs
    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.
     
  10. Lehmden
    • Premium Supporter

    Lehmden Retired Team Member

    Joined:
    December 17, 2010
    Messages:
    11,901
    Likes Received:
    2,151
    Gender:
    Male
    Location:
    Lehmden
    Ratings:
    +3,628 / 28
    Home Country:
    Germany Germany
    Show System Specs
    Hi.
    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.

    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...
     
    • Thank You! Thank You! x 1
  11. ajs
    • Team MediaPortal

    ajs Development Group

    Joined:
    February 29, 2008
    Messages:
    8,829
    Likes Received:
    2,792
    Gender:
    Male
    Occupation:
    IT
    Location:
    Kyiv
    Ratings:
    +4,797 / 30
    Home Country:
    Ukraine Ukraine
    Show System Specs
    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.

    I transferred the the database from MP in Kodi . Unload all NFO, and start the update library on Kodi .
     
Loading...

Users Viewing Thread (Users: 0, Guests: 0)

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice
  • About The Project

    The vision of the MediaPortal project is to create a free open source media centre application, which supports all advanced media centre functions, and is accessible to all Windows users.

    In reaching this goal we are working every day to make sure our software is one of the best.

             

  • Support MediaPortal!

    The team works very hard to make sure the community is running the best HTPC-software. We give away MediaPortal for free but hosting and software is not for us.

    Care to support our work with a few bucks? We'd really appreciate it!