Reply to thread

Message

<blockquote data-quote="MJGraf" data-source="post: 989124" data-attributes="member: 17886">Speed-Comparison to SQLCE:&nbsp;Did the same Import as above (about 24k Music files) with SQLCE. The import stopped after about 48 min due to database size limit (1GB, I could do 2GB by restarting, but this wouldn't bring too much further info).After those 48 min, about 50% of my music collection was imported. That means about 96 min for the whole import - compared to 36 min with SQLite.From what I remember @<a href="https://forum.team-mediaportal.com/members/morpheus_xx.48495/" target="_blank">morpheus_xx</a> reported somewhere that MySQL is about twice as fast as SQLCE - that means on the other hand that SQLite is about 30% faster than MySQL and nearly three times as fast as SQLCE <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite7" alt=":p" title="Stick Out Tongue&nbsp; &nbsp; :p" loading="lazy" data-shortname=":p" />&nbsp;Will try the last optimization mentioned above and report back...</blockquote>

[QUOTE="MJGraf, post: 989124, member: 17886"] Speed-Comparison to SQLCE: Did the same Import as above (about 24k Music files) with SQLCE. The import stopped after about 48 min due to database size limit (1GB, I could do 2GB by restarting, but this wouldn't bring too much further info). After those 48 min, about 50% of my music collection was imported. That means about 96 min for the whole import - compared to 36 min with SQLite. From what I remember @[URL='https://forum.team-mediaportal.com/members/morpheus_xx.48495/']morpheus_xx[/URL] reported somewhere that MySQL is about twice as fast as SQLCE - that means on the other hand that SQLite is about 30% faster than MySQL and nearly three times as fast as SQLCE :p Will try the last optimization mentioned above and report back... [/QUOTE]

Verification