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 261 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.
Could you elaborate on those performance limits ? We're considering storing 5MB BLOBS, and so far the tests worked fine. Where are we likely to hit a bottleneck ? Which pragmas can be tuned ? The DB will be doing mainly sequential inserts. -- ___________________________________________________________ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm
