home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 1
Development
General Development (no feature request here!)
Movie Database workflow - suggestions for improval.
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="HappyTalk" data-source="post: 70286" data-attributes="member: 22671"><p>After a hard days SQLing I managed to completely move all the info from the 6 main tables as used for movie info by MythTV into the many tables of the MediaPortal database + Generated a script to rename the thumbnails and it all works PEFECTLY!</p><p></p><p>However I now have a database with 6,000 video entries (lots of music videos + divx movies, DVD's etc) and to load it up it takes over 1 minute. Once loaded in actual useage it works fine, but if you wish to select say a different genre again it takes another minute to reload. If you press IMDB on an entry to view the IMDB info, when you exit it drops back to the genre list, NOT where you were before so again it's another minute to re-view the list. This obviously makes it unuseable. </p><p></p><p>Having used SQLite with that SQLite Database Browser.exe program extensively in my mythtv migration, it seems very very fast in operation (inserts, joins, exports, searches etc) even with 6k records, so I can only assume that the database code is incredibly inefficient? I also notice there are no indexes used in the database. I'm going to try and add some indexes to see if it improves things, if not I plan to go in and check the code, (I planned to do lots of things but haven't managed yet).</p></blockquote><p></p>
[QUOTE="HappyTalk, post: 70286, member: 22671"] After a hard days SQLing I managed to completely move all the info from the 6 main tables as used for movie info by MythTV into the many tables of the MediaPortal database + Generated a script to rename the thumbnails and it all works PEFECTLY! However I now have a database with 6,000 video entries (lots of music videos + divx movies, DVD's etc) and to load it up it takes over 1 minute. Once loaded in actual useage it works fine, but if you wish to select say a different genre again it takes another minute to reload. If you press IMDB on an entry to view the IMDB info, when you exit it drops back to the genre list, NOT where you were before so again it's another minute to re-view the list. This obviously makes it unuseable. Having used SQLite with that SQLite Database Browser.exe program extensively in my mythtv migration, it seems very very fast in operation (inserts, joins, exports, searches etc) even with 6k records, so I can only assume that the database code is incredibly inefficient? I also notice there are no indexes used in the database. I'm going to try and add some indexes to see if it improves things, if not I plan to go in and check the code, (I planned to do lots of things but haven't managed yet). [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Development
General Development (no feature request here!)
Movie Database workflow - suggestions for improval.
Contact us
RSS
Top
Bottom