On 17 Aug 2016, at 4:54pm, Rousselot, Richard A <richard.a.rousse...@centurylink.com> wrote:
> PRAGMA journal_mode = Off; This configuration is designed for cases where the resulting database will be thrown away soon (e.g. when the application quits). It does increase speed greatly, but a consequence is that the benchmark is not useful as an indicator of performance in the real world. Some of your other PRAGMAs also seem to be suitable only to running benchmarks quickly. A fairer test, one more like real world performance, would be not to use any PRAGMAs at all apart from turning on FOREIGN KEYS. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
