-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 In my testing I am finding that using SQLite's mmap support with larger databases (final db size is ~10GB) to create the database (WAL mode) is considerably (about three times) slower than no mmap.
The default max mmap limit is 2GB (sadly). Has anyone else tested mmap with >2GB databases and have results? I don't know if this is a peculiarity of my data set, or because of how SQLite is implemented. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iEYEARECAAYFAlXDdQMACgkQmOOfHg372QRt3wCeKQpP9g2OhWS2yJg+iU7Gxvxo TPUAn3ikDarecOaKLPIsnS3Xv+IltreU =yUxV -----END PGP SIGNATURE-----