Re: [sqlite] BLOB read/write in chunks?

[Henrik Bruun]

Thanks.  If I try to break these 200MB files into smaller chunks myself 
and insert the pieces into individual rows are there any recommendations 
as to a row size (10K, 64K, 1MB...)?  and do I need to make any *.h 
constant file changes to indicate that I want to work with larger row 
sizes (or was that only applicable in the previous versions)?

D. Richard Hipp wrote:
On Wed, 2005-05-04 at 23:31 -0400, Henrik Bruun wrote:
 

Does Sqlite support reading/writing BLOB data in chunks?  I'm 
considering storing very large items (200MB+) in BLOB fields. 

   

With SQLite, the entire BLOB must be read or written all
at once.  There is no limit on the size of BLOBs.  (The
limit is something like 2^61 bytes - not really a limit.)
But for BLOBs of the size of 200MB, you will likely be
disappointed with the performance.  You'd be better off
to write the information into a file, then store the filename
in the database.