[adzm]

Really, no mmap?

[metrix]

I'm curious what your suggest mmap pragma would be.

[adzm]

PRAGMA mmap_size=268435456;

for example? I'm surprised by the downvotes. Using mmap significantly reduced my average read query time; durations about 70% the length!