aboutsummaryrefslogtreecommitdiffhomepage
path: root/org/out_src_abstraction_sqlite_db.org
diff options
context:
space:
mode:
Diffstat (limited to 'org/out_src_abstraction_sqlite_db.org')
-rw-r--r--org/out_src_abstraction_sqlite_db.org11
1 files changed, 9 insertions, 2 deletions
diff --git a/org/out_src_abstraction_sqlite_db.org b/org/out_src_abstraction_sqlite_db.org
index 31bb7ab..0b477c1 100644
--- a/org/out_src_abstraction_sqlite_db.org
+++ b/org/out_src_abstraction_sqlite_db.org
@@ -73,8 +73,15 @@ template spineAbstractionDb() {
/+ ↓ open database and create schema +/
auto db = Database(db_file);
- db.run("PRAGMA journal_mode=WAL");
- db.run("PRAGMA synchronous=NORMAL");
+ /+ ↓ write once, read many: no WAL.
+ a WAL stamped file cannot be opened by a reader that cannot write
+ beside it (SQLITE_READONLY on a read-only directory, and inside a
+ zip or on read-only media), and this database has one writer and no
+ concurrency, so WAL buys nothing here. MEMORY journal keeps the bulk
+ load fast without leaving that mark on the file.
+ +/
+ db.run("PRAGMA journal_mode=MEMORY");
+ db.run("PRAGMA synchronous=OFF");
db.run("
CREATE TABLE metadata (