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

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,821
    Likes Received:
    2,788
    Gender:
    Male
    Occupation:
    IT
    Location:
    Kyiv
    Ratings:
    +4,788 / 30
    Home Country:
    Ukraine Ukraine
    Show System Specs
    A lot of files on a network drive. I now there are more than 1000. :(


     
  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. Lehmden
    • Premium Supporter

    Lehmden Retired Team Member

    Joined:
    December 17, 2010
    Messages:
    11,897
    Likes Received:
    2,151
    Gender:
    Male
    Location:
    Lehmden
    Ratings:
    +3,627 / 28
    Home Country:
    Germany Germany
    Show System Specs
    Hi.
    It is done in background while you are able to use Kodi as normal. Only the first time it takes long until all media is read. But that is the same as on all other systems, no matter if it is MP or Plex or WMC or,... Once you have all your media in the db you can start using them also the sync is running in background.

    Not more needed to use centralized SQLIte DB in MP1... But without any guarantee... Same is for Kodi, it is also without any support or named as "stable"...
     
  4. ajs
    • Team MediaPortal

    ajs Development Group

    Joined:
    February 29, 2008
    Messages:
    8,821
    Likes Received:
    2,788
    Gender:
    Male
    Occupation:
    IT
    Location:
    Kyiv
    Ratings:
    +4,788 / 30
    Home Country:
    Ukraine Ukraine
    Show System Specs
    Maybe, but this function is a long time. And it works flawlessly. I do not know why it has not yet been carried to the settings. And have not removed the status of "advanced (complicated) and experimental" and replaced it with a stable.
     
  5. ajs
    • Team MediaPortal

    ajs Development Group

    Joined:
    February 29, 2008
    Messages:
    8,821
    Likes Received:
    2,788
    Gender:
    Male
    Occupation:
    IT
    Location:
    Kyiv
    Ratings:
    +4,788 / 30
    Home Country:
    Ukraine Ukraine
    Show System Specs
    PS: When I added support for MySQL in MePoTols, I did not notice the difference in running time between database to SQLite (via a network) and MySQL.
    Both databases are physically located on the same server.
     
  6. 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 can speed up the MySQL on remote: from 6 sec to 4-4.5 sec on same folder. This is not a big result but better than nothing.
     
    • Like Like x 1
    • Informative Informative x 1
  7. ajs
    • Team MediaPortal

    ajs Development Group

    Joined:
    February 29, 2008
    Messages:
    8,821
    Likes Received:
    2,788
    Gender:
    Male
    Occupation:
    IT
    Location:
    Kyiv
    Ratings:
    +4,788 / 30
    Home Country:
    Ukraine Ukraine
    Show System Specs
    Maybe on the server, which indexes to correct? Or where there is a bottleneck? Maybe it makes sense, take all possible data, and then it locally, from memory select?
     
  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 win some ms by rewriting some code. The ms can be second if the iteration is big (many file in one folder). The client caching is bad think because we want to use many clients at same time.
     
    • Like Like x 1
  9. 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
    Another test with database view using Actors view. I have 20000 actors in my test db.

    Old: GUIVideoTitle:LoadDirectory is finished in 162368 ms
    New: GUIVideoTitle:LoadDirectory is finished in 101447 ms
     
    • Like Like x 3
  10. ajs
    • Team MediaPortal

    ajs Development Group

    Joined:
    February 29, 2008
    Messages:
    8,821
    Likes Received:
    2,788
    Gender:
    Male
    Occupation:
    IT
    Location:
    Kyiv
    Ratings:
    +4,788 / 30
    Home Country:
    Ukraine Ukraine
    Show System Specs
    I mean that we should abandon the many small requests in favor of one big one. And then to process the data from it. At least when you open the plug-in, or entering into a new folder.
     
    • Agree Agree x 1
  11. 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
    Attention!!!!

    The new version (MediaPortalSetup_1.11.0_2015-03-21-19-38mysql.zip) requires new database because of the old one was created with wrong characters/collation. Do not install it without drop the old databases! The installer wont drop the databases. You need to do that. Sorry.

    Change log:
    • Little speed improvement
    • Wake On Lan feature for database host
    • Bugfixes
    • Based on 1.11 Final
     
    • Like Like x 2
    • Informative Informative x 1
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!