From 8dcc52ccf9212f7df005cdd14f334466c3ad171a Mon Sep 17 00:00:00 2001 From: Matt Joiner Date: Thu, 6 May 2021 15:25:01 +1000 Subject: [PATCH] Don't set the page size by default --- storage/sqlite/sqlite-storage.go | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/storage/sqlite/sqlite-storage.go b/storage/sqlite/sqlite-storage.go index f6854791..ed9aefb3 100644 --- a/storage/sqlite/sqlite-storage.go +++ b/storage/sqlite/sqlite-storage.go @@ -299,7 +299,10 @@ func newOpenUri(opts NewConnOpts) string { func initDatabase(conn conn, opts InitDbOpts) (err error) { if !opts.DontInitSchema { if opts.PageSize == 0 { - opts.PageSize = 1 << 14 + // There doesn't seem to be an optimal size. I did try with the standard chunk size, but + // the difference is not convincing. + + //opts.PageSize = 1 << 14 } err = InitSchema(conn, opts.PageSize, !opts.NoTriggers) if err != nil { -- 2.48.1