From 55bb16b34f2d72fc443e9b3864b299cf12b7a7b7 Mon Sep 17 00:00:00 2001 From: "Frank Ch. Eigler" Date: Tue, 30 Jul 2019 11:00:21 -0400 Subject: dbgserver: prefer wal logging for sqlite db --- dbgserver/dbgserver.cxx | 1 + 1 file changed, 1 insertion(+) (limited to 'dbgserver') diff --git a/dbgserver/dbgserver.cxx b/dbgserver/dbgserver.cxx index 2850c51e..ff2b0b9e 100644 --- a/dbgserver/dbgserver.cxx +++ b/dbgserver/dbgserver.cxx @@ -97,6 +97,7 @@ using namespace std; static const char DBGSERVER_SQLITE_DDL[] = "pragma foreign_keys = on;\n" "pragma synchronous = 0;\n" // disable fsync()s - this cache is disposable across a machine crash + "pragma journal_mode = wal;\n" // https://sqlite.org/wal.html /* Normalized tables to represent general buildid-to-file/subfile mapping. */ "create table if not exists " BUILDIDS "_files (\n" -- cgit v1.2.1