SQLite Forum

Understanding memory allocation behavior of SQLite
Same anonymous here!

Forgot to say, one way to quickly test this (and reduce allocations a lot as well) is to try using a smaller page size, unless your records are really fat may be you should try 1KB or even 512B