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: 988832" data-attributes="member: 17886"><p>Here we go!</p><p> </p><p>Attached is a working version of the SQLiteDatabase - source code and debug binaries.</p><p>If you want to test, please remove your former database plugin (MSSQLCE or MySQL) and instead copy the attached SQLiteDatabase plugin in your MP2-Server's plugin directory.</p><p>No configuration needed at all. There will just be one database file in your ProgramData\Team Mediaportal\MP2-Server directory.</p><p> </p><p>The database seems more efficient than the MSSQLCE database as regards database file size. My music collection consists of about 24k files, thoroughly tagged, each file with a (relatively) high res embedded cover. While the MSSQLCE database was not able to Import my whole Music collection (due to the 2GB size Limit), SQLite imported all the files and the database file size was still below 2GB.</p><p> </p><p>I would therefore be grateful If someone with a REALLY big Music collection (@<a href="https://forum.team-mediaportal.com/members/lehmden.109222/" target="_blank">Lehmden</a> <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite2" alt=";)" title="Wink ;)" loading="lazy" data-shortname=";)" /> ) could try if the Import works correctly with this database plugin, even when the database file size goes beyond 2GB.</p><p> </p><p>I haven't done a speed test, yet, in comparison to MSSQLCE and MySQL. So this is just my feeling, but the feeling is that SQLite is really fast. Speed comparison tests are also welcome.</p><p> </p><p>There is still a lot of room for improvement. In particular with respect to databse locking and connection handling (currently, I just set the timeout to 30s for the database connection. That's the same way that this is done in the MSSQLCE database plugin. This works, because no wuery should take longer than 30s - but there are surely better and even faster solutions.</p><p> </p><p>Any input is welcome!</p><p> </p><p>Michael</p><p> </p><p>[Attachment removed - please use version from first post]</p></blockquote><p></p>
[QUOTE="MJGraf, post: 988832, member: 17886"] Here we go! Attached is a working version of the SQLiteDatabase - source code and debug binaries. If you want to test, please remove your former database plugin (MSSQLCE or MySQL) and instead copy the attached SQLiteDatabase plugin in your MP2-Server's plugin directory. No configuration needed at all. There will just be one database file in your ProgramData\Team Mediaportal\MP2-Server directory. The database seems more efficient than the MSSQLCE database as regards database file size. My music collection consists of about 24k files, thoroughly tagged, each file with a (relatively) high res embedded cover. While the MSSQLCE database was not able to Import my whole Music collection (due to the 2GB size Limit), SQLite imported all the files and the database file size was still below 2GB. I would therefore be grateful If someone with a REALLY big Music collection (@[URL='https://forum.team-mediaportal.com/members/lehmden.109222/']Lehmden[/URL] ;) ) could try if the Import works correctly with this database plugin, even when the database file size goes beyond 2GB. I haven't done a speed test, yet, in comparison to MSSQLCE and MySQL. So this is just my feeling, but the feeling is that SQLite is really fast. Speed comparison tests are also welcome. There is still a lot of room for improvement. In particular with respect to databse locking and connection handling (currently, I just set the timeout to 30s for the database connection. That's the same way that this is done in the MSSQLCE database plugin. This works, because no wuery should take longer than 30s - but there are surely better and even faster solutions. Any input is welcome! Michael [Attachment removed - please use version from first post] [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 2
Plugin Development
SQLiteDatabase Plugin for MP2
Contact us
RSS
Top
Bottom