SQLite Forum

mmap and blobs
> Am I right in concluding that directly mapping internal blobs to memory is not possible?

Blobs may span multiple db pages and thus not all bytes in them will necessarily reside in contiguous on-storage memory, making them incompatible with direct memory mapping.

Consider what would happen if they *were* mmapped and their records were deleted while you were using them (and then those db pages reused for other records).

*That Way Lies Madness*.