diff options
| author | Eric Wong <e@yhbt.net> | 2020-07-01 21:06:19 +0000 |
|---|---|---|
| committer | Eric Wong <e@yhbt.net> | 2020-07-02 20:36:21 +0000 |
| commit | 9ccff7954bf4209babc3d4b0d95b5b933d945ba2 (patch) | |
| tree | 930b828618d7df6d20ad50af475fb7e7883d94c3 | |
| parent | 542caf3a9b33ac59205cb7e1b92cfe4b4e8257e7 (diff) | |
| download | public-inbox-9ccff7954bf4209babc3d4b0d95b5b933d945ba2.tar.gz | |
I was wondering about this myself the other day and had to read up on it. So make a note of it for future readers.
| -rw-r--r-- | lib/PublicInbox/OverIdx.pm | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/lib/PublicInbox/OverIdx.pm b/lib/PublicInbox/OverIdx.pm index c7f45a6c..008a5d1a 100644 --- a/lib/PublicInbox/OverIdx.pm +++ b/lib/PublicInbox/OverIdx.pm @@ -23,6 +23,8 @@ sub dbh_new { my $dbh = $self->SUPER::dbh_new(1); # TRUNCATE reduces I/O compared to the default (DELETE) + # We do not use WAL since we're optimized for read-only ops, + # (and read-only requires SQLite 3.22.0 (2018-01-22)). $dbh->do('PRAGMA journal_mode = TRUNCATE'); # 80000 pages (80MiB on SQLite <3.12.0, 320MiB on 3.12.0+) |