On 6 Aug 2014, at 11:00pm, big stone <stonebi...@gmail.com> wrote: > I too noticed disappointing improvements by going ":memory:". > But, it seems also very dependent of the compilation options and the > version of SQLite you use. > > sometimes, gain is roughly 0% > sometimes, gain can be 40%.
Pagesize for the disk version can make a surprisingly big difference. There's not that much you can do about it since the majority of influences on SQLite speed are from things you have no control over, like the storage driver's cache strategy, and the OS's process scheduling. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users