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 2
Plugin Development
SQLiteDatabase Plugin for MP2
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="MJGraf" data-source="post: 1028195" data-attributes="member: 17886"><p>ok - difference is not big:</p><p>Import time down to 30:31 from about 31 minutes.</p><p>Filesize down to 1.770.092 kb from 1.773.888 KB</p><p>Doesn't give enough speed-up to deal with that now since it requires changes to MP2 core code. But nevertheless we should keep it in mind as IMO this is just wrong.</p><p>@[USER=48495]morpheus_xx[/USER]: I know you are busy with putting the release together - but if you find the time, could you check whether MySQL also auto creates an index on PRIMARY KEY columns? Thanks!</p><p></p><p>For my further tests, I will again use the original database generated by MP2 and not the tweaked one from the last test.</p><p>Michael</p></blockquote><p></p>
[QUOTE="MJGraf, post: 1028195, member: 17886"] ok - difference is not big: Import time down to 30:31 from about 31 minutes. Filesize down to 1.770.092 kb from 1.773.888 KB Doesn't give enough speed-up to deal with that now since it requires changes to MP2 core code. But nevertheless we should keep it in mind as IMO this is just wrong. @[USER=48495]morpheus_xx[/USER]: I know you are busy with putting the release together - but if you find the time, could you check whether MySQL also auto creates an index on PRIMARY KEY columns? Thanks! For my further tests, I will again use the original database generated by MP2 and not the tweaked one from the last test. Michael [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 2
Plugin Development
SQLiteDatabase Plugin for MP2
Contact us
RSS
Top
Bottom
