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
Plugin: MySQL database provider - better performance and no size limit for your MP2-MediaLibrary
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="Lehmden" data-source="post: 1278971" data-attributes="member: 109222"><p>Hi.</p><p>This Database provider is obsolete as it has no advantages but only disadvantages compared to the now (since a long time) default SQLite (that is included in the main installer package for sure). SQLite needs no external database server, it also is unlimited in DB size and it's ten times faster than MySQL (real live speed tested by ourselves). The only "downside" of SQLite is that there can be only one writing access at a time. Opposite to MP1 where everyone can fiddle around with the database of TV server the MP2 server is the only task that read and write to the MP2 database. Sp this is no disadvantage in this use case. I was part of the testing team as we finally (but very easily in the end) decided to go with SQLite. It definitely is way better than any other option we could test ... </p><p></p><p>MySQL (that meanwhile is commercial, so it should be MariaDB instead nowadays) is the db engine to choose if you need a "multi- user from multi- location" access to the database. This is valid for MP1 and also for Kodi, but this is not the case for MP2. Under "one- user from one location only" access as it is the case for MP2, SQLite is the much better, the best choice without any doubt.</p></blockquote><p></p>
[QUOTE="Lehmden, post: 1278971, member: 109222"] Hi. This Database provider is obsolete as it has no advantages but only disadvantages compared to the now (since a long time) default SQLite (that is included in the main installer package for sure). SQLite needs no external database server, it also is unlimited in DB size and it's ten times faster than MySQL (real live speed tested by ourselves). The only "downside" of SQLite is that there can be only one writing access at a time. Opposite to MP1 where everyone can fiddle around with the database of TV server the MP2 server is the only task that read and write to the MP2 database. Sp this is no disadvantage in this use case. I was part of the testing team as we finally (but very easily in the end) decided to go with SQLite. It definitely is way better than any other option we could test ... MySQL (that meanwhile is commercial, so it should be MariaDB instead nowadays) is the db engine to choose if you need a "multi- user from multi- location" access to the database. This is valid for MP1 and also for Kodi, but this is not the case for MP2. Under "one- user from one location only" access as it is the case for MP2, SQLite is the much better, the best choice without any doubt. [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 2
Plugin Development
Plugin: MySQL database provider - better performance and no size limit for your MP2-MediaLibrary
Contact us
RSS
Top
Bottom