diff options
author | Harald Welte <laforge@gnumonks.org> | 2016-05-03 18:50:41 +0200 |
---|---|---|
committer | Harald Welte <laforge@gnumonks.org> | 2016-05-03 18:50:41 +0200 |
commit | abd1a5418371b16136ddf28545eb0721d794c08e (patch) | |
tree | 26c9bdfe627e20de3a74d1eb4321bd795b961f46 /src | |
parent | e687be5f2db2302c82ee2b0bffa1c6f69b5fe278 (diff) |
db: Use Write-Ahead Logging mode of SQLite3
Diffstat (limited to 'src')
-rw-r--r-- | src/db.c | 6 |
1 files changed, 6 insertions, 0 deletions
@@ -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, |