2 MB, not 2 GB.
-----Original Message----- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Warren Young Sent: Thursday, June 14, 2018 5:54 PM To: SQLite mailing list Subject: Re: [sqlite] .timer By default, SQLite will only cache a smidge under 2 GiB, so it cannot explain your result: https://sqlite.org/pragma.html#pragma_cache_size _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users