Reply to thread

Message: <blockquote data-quote="MJGraf" data-source="post: 989149" data-attributes="member: 17886">Ok, the last test for me today was with only one change compared to v0.2. In the connection string I added<ul> <li data-xf-list-type="ul">SyncMode=SynchronizationModes.Normal</li> </ul>Details can be found here: <a href="http://www.sqlite.org/pragma.html#pragma_synchronous" target="_blank">http://www.sqlite.org/pragma.html#pragma_synchronous</a> . With this setting, a transaction may not survive a power loss (but of course the database itself does), which is ok imo.We could have more speed improvements by using SynchronizationModes.Off, but then the database may become corrupted in case of a power loss and this is something that gets on my nervers with the MP1-TVServer database already, so I want to avoid that in MP2... Result is as follows:Same import as above (24k music files)Import took 30 min - now it's more than three times as fast as SQLCE...This is noticably a further speed improvement, so I think we should use this further setting (I have no idea, whether MP2 could even cope with a non-committed transaction, which is still there after a power loss, so this tradeoff seems to be acceptable).Attached is therefore a v0.3 - only change to v0.2 is the setting above. As a result, the v0.2 database file IS compatible with the v0.3 version. No changes to the database structure were introduced. What I also did is just copy part of my music collection and import that as well. This now brought me a database file size > 2GB and this also worked without a problem. <a href="http://www.sqlite.org/limits.html" target="_blank">http://www.sqlite.org/limits.html</a> reports that the maximum database file size is about 140TB - should be enough for most use cases <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite2" alt=";)" title="Wink    ;)" loading="lazy" data-shortname=";)" /> I'd be glad if we could get some more testing on this provider. Since it is much faster than SQLCE and has no database file size limitations, I'm tempted to propose this as new standard database provider. Furthermore it includes only one dll, which is much smaller than all the SQLCE-DLLs and I think there are also NUGet-packages available, which should make @<a href="https://forum.team-mediaportal.com/members/chefkoch.10438/" target="_blank">chefkoch</a> happy <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite7" alt=":p" title="Stick Out Tongue    :p" loading="lazy" data-shortname=":p" /> But for this to happen we need MUUUUUCH more testing, since the database is really a core component of MP2 (and we also need to sort out Morph's comment regarding the native TV provider, but I don't think this is a real problem...) Michael [Attachment removed - please use version from first post]</blockquote>

Verification