Reply to thread

Message: <blockquote data-quote="MJGraf" data-source="post: 1035697" data-attributes="member: 17886">Oh, and just for the fun of it:SQlite is able to create pure in-memory databases. That's basically the same as when you, breese, put your database on a RAM drive - just without the overhead of the RAM drive software and the windows file system. I just did an import run with a pure in-memory database and after about 3/4 of the import I got an out-of-memory.exception <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite8" alt=":D" title="Big Grin    :D" loading="lazy" data-shortname=":D" />The interesting part is: When I take the time until the exception was thrown and calculate how long it would have taken until the import would have been finished, I end up with something like 16-17 minutes for my ImportTest. Compared to the 20 minutes with my SSD, this is quite a long time - so my suspicion is that the database is already quite effective. Most of the time is probably spent by reading the tags from the files...But I have one further idea: Does anyone know whether our ThumbnailSmall and ThumbnailLarge aspects hold compressed image data (e.g. the bytes directly from the compressed jpg file) or is this uncompressed image data? In the latter case, it makes sense that we compress the byte[] data before we store it in the database - for performance and for storage space reasons...And breese: thanks again for all your help. I know I'm teasing all of you for quite some time now, but I don't want to have too many beta versions out there... As soon as the new system.data.sqlite version is out, I'll integrate it and publish a test version. I'm looking at the system.data.sqlite homepage everyday waiting for the new version to be published <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite8" alt=":D" title="Big Grin    :D" loading="lazy" data-shortname=":D" /></blockquote>

Verification