From e2959032031097533071cc9eb51f2acd6d7c4fdf Mon Sep 17 00:00:00 2001 From: Mu-Woong Lee Date: Thu, 7 Apr 2016 17:15:46 +0900 Subject: [PATCH] Apply journal_mode = WAL to the DB Change-Id: I1c59e3cd255167b8657f98e03032f1e6c47d5d09 Signed-off-by: Mu-Woong Lee --- src/db_mgr_impl.cpp | 12 ++++++++++-- 1 file changed, 10 insertions(+), 2 deletions(-) diff --git a/src/db_mgr_impl.cpp b/src/db_mgr_impl.cpp index 40e30c0..8c6a36b 100644 --- a/src/db_mgr_impl.cpp +++ b/src/db_mgr_impl.cpp @@ -59,9 +59,17 @@ void ctx::db_manager_impl::release() bool ctx::db_manager_impl::open() { sqlite3 *db = NULL; - int r = sqlite3_open(CONTEXT_DB_PATH, &db); + char *err = NULL; + int ret; + + ret = sqlite3_open(CONTEXT_DB_PATH, &db); + IF_FAIL_RETURN_TAG(ret == SQLITE_OK, false, _E, "Path: %s / Error: %s", CONTEXT_DB_PATH, sqlite3_errmsg(db)); - IF_FAIL_RETURN_TAG(r == SQLITE_OK, false, _E, "Path: %s / Error: %s", CONTEXT_DB_PATH, sqlite3_errmsg(db)); + ret = sqlite3_exec(db, "PRAGMA journal_mode = WAL", NULL, NULL, &err); + if (ret != SQLITE_OK) { + _E("Setting journal mode failed: %s", err); + sqlite3_free(err); + } db_handle = db; return true; -- 2.34.1