On 08/06/2015 09:53 PM, Roger Binns wrote: > -----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.
Is it using more CPU cycles in mmap mode or just taking longer? If the former, does [time] attribute them to "user" or "system"? How large are you letting the wal file grow between checkpoints? Dan. > > Roger > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1 > > iEYEARECAAYFAlXDdQMACgkQmOOfHg372QRt3wCeKQpP9g2OhWS2yJg+iU7Gxvxo > TPUAn3ikDarecOaKLPIsnS3Xv+IltreU > =yUxV > -----END PGP SIGNATURE----- > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users