search

bricelam / bricelam.github.io

Highlighting some of my more technical adventures
bricelam.net
3 stars 2 forks source link

Microsoft.Data.Sqlite 3.0 #30

Closed utterances-bot closed 1 year ago

utterances-bot commented 3 years ago

Microsoft.Data.Sqlite 3.0 | Brice’s Blog

Version 3.0 of Microsoft.Data.Sqlite is available on NuGet. It was released alongside the rest of .NET Core 3.0 at .NET Conf.

https://www.bricelam.net/2019/08/22/microsoft-data-sqlite-3-0.html

maumi commented 3 years ago

Hey Brice, I use the SqliteBlob to stream Files from/to Sqlite. The insert works flawless, but when I get the file as a stream out of the sqlite DB the memory spikes additional to the full size of the file (which was the main reason for me to avoid this with streaming). The spike is at the ExecuteReader line, I've also tried to set the CommandBehaviour to SequentialAccess but this also changes nothing. Any help would be highly recommended.

bricelam commented 3 years ago

(We investigated the allocation in https://github.com/dotnet/efcore/issues/24312)