These DBs will probably be too small to be worth increasing the cache size of. --- lib/PublicInbox/SharedKV.pm | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-)
diff --git a/lib/PublicInbox/SharedKV.pm b/lib/PublicInbox/SharedKV.pm index b0588060..d65c3158 100644 --- a/lib/PublicInbox/SharedKV.pm +++ b/lib/PublicInbox/SharedKV.pm @@ -27,7 +27,9 @@ sub dbh { }); my $opt = $self->{opt} // {}; $dbh->do('PRAGMA synchronous = OFF') if !$opt->{fsync}; - $dbh->do('PRAGMA cache_size = '.($opt->{cache_size} || 80000)); + if (my $s = $opt->{cache_size}) { + $dbh->do("PRAGMA cache_size = $s"); + } $dbh->do('PRAGMA journal_mode = '. ($opt->{journal_mode} // 'WAL')); $dbh->do(<<''); -- unsubscribe: one-click, see List-Unsubscribe header archive: https://public-inbox.org/meta/