[EMAIL PROTECTED] wrote: > Maybe I'm missing something here, but there should be an interface to page a > blob into memory. Especially for large blobs, this would make sense to me to > not load them into memory at once. > > If sqlite doesn't provide this already, it would probably make a lot of sense > to include this functionality or to propagate it to the SQL layer. >
The current SQLite file format precludes this. If you want to be able to page-read BLOBs, that would require SQLite version 4. -- D. Richard Hipp <[EMAIL PROTECTED]>