* [PATCH 5/5] overidx: document why we don't use SQLite WAL
2020-07-01 21:06 4% [PATCH 0/5] some random minor fixes Eric Wong
@ 2020-07-01 21:06 7% ` Eric Wong
0 siblings, 0 replies; 2+ results
From: Eric Wong @ 2020-07-01 21:06 UTC (permalink / raw)
To: meta
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.
---
lib/PublicInbox/OverIdx.pm | 2 ++
1 file changed, 2 insertions(+)
diff --git a/lib/PublicInbox/OverIdx.pm b/lib/PublicInbox/OverIdx.pm
index c7f45a6c910..008a5d1a936 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+)
^ permalink raw reply related [relevance 7%]
* [PATCH 0/5] some random minor fixes
@ 2020-07-01 21:06 4% Eric Wong
2020-07-01 21:06 7% ` [PATCH 5/5] overidx: document why we don't use SQLite WAL Eric Wong
0 siblings, 1 reply; 2+ results
From: Eric Wong @ 2020-07-01 21:06 UTC (permalink / raw)
To: meta
Bigger changes are brewing in other branches...
Eric Wong (5):
spawn: make @RLIMITS a shared list
spawn: modernize with parent.pm, drop warnings.pm
watch: retry signals to kill IDLE and polling processes
tests: add use/require statements for TEST_RUN_MODE=0
overidx: document why we don't use SQLite WAL
lib/PublicInbox/InboxWritable.pm | 1 +
lib/PublicInbox/OverIdx.pm | 2 ++
lib/PublicInbox/Qspawn.pm | 4 ++--
lib/PublicInbox/Spawn.pm | 7 +++----
lib/PublicInbox/WatchMaildir.pm | 27 ++++++++++++++++++---------
t/init.t | 1 +
t/nntpd.t | 1 +
7 files changed, 28 insertions(+), 15 deletions(-)
^ permalink raw reply [relevance 4%]
Results 1-2 of 2 | reverse | options above
-- pct% links below jump to the message on this page, permalinks otherwise --
2020-07-01 21:06 4% [PATCH 0/5] some random minor fixes Eric Wong
2020-07-01 21:06 7% ` [PATCH 5/5] overidx: document why we don't use SQLite WAL Eric Wong
Code repositories for project(s) associated with this public inbox
https://80x24.org/public-inbox.git
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).