(2014-07-26 12:33)m.savazzi Wrote: I think I will propose a slightly different approach that should be more flexible and future proof. Also I'm looking at one db for everything not just the video partSince this is now really a different scope than your original post you should probably start over with a new thread instead of continuing here, as I bet you will get more more attention with a such new thread with a better subject topic description that simply doesn't involve small performance optimizations.
Oh, and with RetroPlayer being mainlined sooner or later might as well consider adding stand-alone games and game ROMs launched via emulators into the scope of the database model right away as well.
Would also be nice if music and music videos could be combined, or at least linked and share information. Just like movies and tv shows / episodes could be linked, or how movies and movie soundtracks could be linked. And how actors / actresses and movies / tv shows / episodes are linked today.