System.Data.SQLite

 Hi there,

In order to reduce the amount of memory used when writing a BLOB value, is it possible to write the BLOB to the database in "chunks" using the ADO.NET 2.0 Provider?

Hi! Dig deep about incremental read and write in sqlite.org, e.g. http://www.sqlite.org/c3ref/blob_write.html
dont know if system.data.sqlite can do that :(

Hi there,

In order to reduce the amount of memory used when writing a BLOB value, is it possible to write the BLOB to the database in "chunks" using the ADO.NET 2.0 Provider?

 I'm making an application to use the ADO.NET 2.0 Provider.

 I'm in a great hurry, you know want to help.

Hi I've had the same problem. It seems that the current version of the .net provider does not support this functionality even though the sqlite library supports it. I've wrote a simple example that you can copy and paste to your application. I hope it will help you. Note that you can't use the chunking API if the BLOB is NULL so you'd better check this before actually trying to use it.

Was a temporary response.
I will create a separate table, which is divided to register there.

Thank you.

See this forum post.