-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 https://sqlite.org/mmap.html
SQLite supports memory mapping databases, but only does so for the first 2GB of the file. My databases are around 4 to 20GB, and completely fit within RAM on my 64 bit systems. The 2GB mmap limit means that only a portion of the file benefits from the improved performance, and much effort is wasted copying the data around bits of memory. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iEYEARECAAYFAlYzvnsACgkQmOOfHg372QTLyQCg2Hbf8V/4xPt7OA6s0bK6U7Ob Qp4An1LOw8nl9DAHoK07ykY+DIFaa/jS =iTb4 -----END PGP SIGNATURE-----