Database: Refactor MP1 database for multi seat usage (4 Viewers)

ajs

Development Group
  • Team MediaPortal
  • February 29, 2008
    14,138
    8,690
    Kyiv
    Home Country
    Ukraine Ukraine
    Is anyone using this option and what is it for (and what is it expected to do if you don't store your movies in separate folders in the first place)?
    Once I used it, it is convenient, there is less visual garbage when browsing the catalog. But that was a long time ago, here you need to look at the Media Portal code and the code of all grabbers.
     

    Anthony Vaughan

    MP Donator
  • Premium Supporter
  • June 25, 2015
    474
    234
    Home Country
    United Kingdom United Kingdom
    I use it because when you use the create .nfo command in video GUI the .nfo file along with cover and fanart are all in the same folder with the movie.
    Okay.

    The reason I asked this question is because, when this option is selected, the fetch processing uses the folder name instead of the movie name, in the grabbers, to find a match. Therefore, if you select this option, but actually put all of your movies in a single folder (as I do), the grabber returns a list of matches to all of your movies (up to the limit you have set).

    This had me thrown until I looked at the code. Why the processing uses the folder name, when you've already got the movie name is a mystery to me.

    I think this code needs to be changed to always use the movie name because the current behavior is really confusing to the user - including me.

    I now notice that the configuration app has an option to 'Prefer video filename for movie search'. I suggest that this option should default to ON because, in my view, it is by no means obvious what it's implications are until you get some weird behavior as I explained above.
     
    Last edited:

    Anthony Vaughan

    MP Donator
  • Premium Supporter
  • June 25, 2015
    474
    234
    Home Country
    United Kingdom United Kingdom
    I don't know English well, but I repeat once again, it takes me a few seconds to get a complete list of actors, which grabber do you use? And you can log with debug information where you can see that getting the list takes a lot of time. Well, one more thing, the grabber is engaged in obtaining the list of actors, information on the actors, and not the Media Portal, recording to the database is generally instantaneous.
    I removed all of the actor information processing to check your hypothesis that it is getting the actor info that is slow - it made no difference.

    I'll have a look at the actor retrieval process again to see if there is any unnecessary processing going on there. I think the problem is in the getting of all actors for a movie. I don't think it is anything to do with the grabbers, but I'll check. I suspect it is an iteration issue.
     

    Anthony Vaughan

    MP Donator
  • Premium Supporter
  • June 25, 2015
    474
    234
    Home Country
    United Kingdom United Kingdom
    I don't know English well, but I repeat once again, it takes me a few seconds to get a complete list of actors, which grabber do you use? And you can log with debug information where you can see that getting the list takes a lot of time. Well, one more thing, the grabber is engaged in obtaining the list of actors, information on the actors, and not the Media Portal, recording to the database is generally instantaneous.
    Well, I finally got there. It was your hint about actor info that led me to the solution.

    I think there is a little confusion with terminology as well that can lead to confusion. In the GUI, the settings refer to actor 'details' and in the column heading in the configuration app it says actor details:

    1636709100709.png


    In the database this information is held in a table called 'actorinfo' and other screen objects refer to this as actor info, which is really the same as actor details.

    When you want actor details, the grabber and MP apps have to do a lot more work, which I mistook for being caused by looking for all actors in a movie when it was actually getting actor details/info. When the grabber doesn't do all of the iterations (the extra work), the actor info table gets very little information. It may be worth looking at why it needs so much extra work to get the full actor info because I suspect there is a way to get that data without all of the extra processing.

    In the meantime, I'll change the wording on the screen (configuration) to make it clear that it is actor details that will be optional.

    Thanks for helping me to finally get this sorted out.
     

    TLD

    Portal Pro
    October 26, 2007
    718
    131
    Rainy Washington
    Home Country
    United States of America United States of America
    Okay.

    The reason I asked this question is because, when this option is selected, the fetch processing uses the folder name instead of the movie name, in the grabbers, to find a match. Therefore, if you select this option, but actually put all of your movies in a single folder (as I do), the grabber returns a list of matches to all of your movies (up to the limit you have set).

    This had me thrown until I looked at the code. Why the processing uses the folder name, when you've already got the movie name is a mystery to me.

    I think this code needs to be changed to always use the movie name because the current behavior is really confusing to the user - including me.

    I now notice that the configuration app has an option to 'Prefer video filename for movie search'. I suggest that this option should default to ON because, in my view, it is by no means obvious what it's implications are until you get some weird behavior as I explained above.
    I think you may run into problems with multi part movies if not using the folder names to search.
     

    ajs

    Development Group
  • Team MediaPortal
  • February 29, 2008
    14,138
    8,690
    Kyiv
    Home Country
    Ukraine Ukraine
    When you want actor details, the grabber and MP apps have to do a lot more work, which I mistook for being caused by looking for all actors in a movie when it was actually getting actor details/info. When the grabber doesn't do all of the iterations (the extra work), the actor info table gets very little information. It may be worth looking at why it needs so much extra work to get the full actor info because I suspect there is a way to get that data without all of the extra processing.
    Getting information about the actor depends on the grabber, whether the actor has an IMDB ID and on the method of getting this information, if you use API, it's almost instantaneous, but there is a minimum of information. If IMDB site is used, then for each actor we get about 3 pages of text, which need to be processed, parsed, and given to MP1. This takes time. And it depends on the computer, internet, and connection time to the IMDB site.

    I think this code needs to be changed to always use the movie name because the current behavior is really confusing to the user - including me.
    There are many nuances, DVD images, DB images, here the file names will be the same. Also movies consisting of parts, etc., etc. Or with a common name.
    Movies\The Think (1998)\movie.mkv
     

    framug

    Super Moderator
  • Team MediaPortal
  • January 31, 2005
    4,934
    919
    South of France
    Home Country
    France France
    @Anthony Vaughan, if I can :
    You propose many things, wich is good.
    Therefore, maybe should/could you separate ?
    Example (but not limited one) .
    One for DB improvment, handling the multi clients concurrency.
    Second, for actor informations/processes.
    Actually, I'm not sure your entire solution could be integrated easyly...
    Just my 2 cents... ;)
     

    framug

    Super Moderator
  • Team MediaPortal
  • January 31, 2005
    4,934
    919
    South of France
    Home Country
    France France
    Yep,
    An example :
    Same for TimeShift buffer display delay integrated but, without all demands for another Team member... :(
    But since it's working during many release without users complain, discuss could be reopened. :)
    But, this is another story... :p
    To summarize : make it simple at the first stage :D
     

    Users who are viewing this thread

    Similar threads

    Hi, must be really a while, cuz I can not remember any post from you ;) But might be also that I joined the team too late. Yes, there will be many things. Main reason is simply, that MP2 is not developed based on MP1. I for example never used MP1. I tried it lately to test voice control and was shocked about many inconsistancies in...
    Hi, must be really a while, cuz I can not remember any post from you ;) But might be also that I joined the team too late. Yes...
    It´s been a while... :) Well, simply the reason is cause MP1 was working so well... :) Now I decided to upgrade my old servers and...
    Replies
    1
    Views
    240
    Ok, the importer also remembers the queue of items that are still needed to be processed in settings file. If there is something stuck, it will try again on next server start and probably stuck again. But removing the media source also removes the associated queue. The server's TV plugin automatically creates the media sources for...
    Ok, the importer also remembers the queue of items that are still needed to be processed in settings file. If there is something...
    Hi, I’ve been struggling with MP 2 now for several weeks. Initially all was fine. Then in the client, the listings of recorded TV...
    Replies
    8
    Views
    911
    It is looking and working very well now and I am almost at the point of switching my HTPC to MP2, madvr would definitely push me over the edge for sure.;)
    It is looking and working very well now and I am almost at the point of switching my HTPC to MP2, madvr would definitely push me...
    We are proud to present MediaPortal 2.3 MediaPortal 2.3 is a full-blown media center software that addresses the most common user...
    Replies
    4
    Views
    3K
    MP1 MP2 MP2 DLNA status? DE
    What I meant is that we have a MP2 plugin called UPnP Render that can play media from DLNA servers if I remember correctly. I don't know the current state of the plugin though. That's why MP2 probably never will be certified. ;) Yes, that was also the idea, but it is a big job as all TV's, software etc. seems to not do everything...
    What I meant is that we have a MP2 plugin called UPnP Render that can play media from DLNA servers if I remember correctly. I don't...
    So I'm wondering what the state of play is with MP2 and DLNA functionality? When I started this post, I did see some posts...
    Replies
    10
    Views
    1K
    Thank you joecrow! It seems to resolve the problem I got since 1.22.
    Thank you joecrow! It seems to resolve the problem I got since 1.22.
    Hi Guys, Most times I have had an issue with MP1 it has been a platform/OS/finger-trouble issue that a re-install etc fixes...
    Replies
    9
    Views
    984
    Top Bottom