datasette icon indicating copy to clipboard operation
datasette copied to clipboard

Published 20 hours ago • verified publisher icon simonw

Experiment with PRAGMA mmap_size=N

Open simonw opened this issue 4 years ago • 3 comments

https://sqlite.org/mmap.html - SQLite supports memory-mapped I/O but it's disabled by default. The PRAGMA mmap_size=N option can be used to enable it.

It would be very interesting to understand the impact this could have on Datasette performance for various different shapes of data.

simonw avatar Jan 23 '21 21:01 simonw