From 2bb6f91a56a730a0423b03906e63430a686b484b Mon Sep 17 00:00:00 2001 From: Harald Welte Date: Tue, 3 May 2016 18:50:41 +0200 Subject: db: Use Write-Ahead Logging mode of SQLite3 --- osmo-gsup-hlr/src/db.c | 6 ++++++ 1 file changed, 6 insertions(+) diff --git a/osmo-gsup-hlr/src/db.c b/osmo-gsup-hlr/src/db.c index 4424307..82c901b 100644 --- a/osmo-gsup-hlr/src/db.c +++ b/osmo-gsup-hlr/src/db.c @@ -105,6 +105,12 @@ struct db_context *db_open(void *ctx, const char *fname) if (rc != SQLITE_OK) LOGP(DDB, LOGL_ERROR, "Unable to enable SQlite3 extended result codes\n"); + char *err_msg; + rc = sqlite3_exec(dbc->db, "PRAGMA journal_mode=WAL; PRAGMA synchonous = NORMAL;", 0, 0, &err_msg); + if (rc != SQLITE_OK) + LOGP(DDB, LOGL_ERROR, "Unable to set Write-Ahead Logging: %s\n", + err_msg); + /* prepare all SQL statements */ for (i = 0; i < ARRAY_SIZE(dbc->stmt); i++) { rc = sqlite3_prepare_v2(dbc->db, stmt_sql[i], -1, -- cgit v1.2.3