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. -- D. Richard Hipp <[EMAIL PROTECTED]>
