> On Oct 15, 2016, at 11:10 AM, Clemens Ladisch <clem...@ladisch.de> wrote: > > In practice, this does not matter unless you have large strings/blobs > that must be read from overflow pages.
I do, actually, which is why I asked. One of the columns is a blob holding a JSON document that can be arbitrarily large. It sounds like including this column in the SELECT clause will cause the entire blob to be read from disk? I definitely don’t want that. What if I’ve enabled memory-mapping? In that case will the register merely point to where the blob data is mapped into memory, without incurring any I/O until I access that memory? (Maybe that’s naïve; I know SQLite isn’t LMDB. I don’t have any insight into how it makes use of memory mapping.) —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
