diff options
| author | Adam Ierymenko <adam.ierymenko@gmail.com> | 2016-02-04 14:03:37 -0800 |
|---|---|---|
| committer | Adam Ierymenko <adam.ierymenko@gmail.com> | 2016-02-04 14:03:37 -0800 |
| commit | 13b39a0c3e11ae44277599dc01512d620197b407 (patch) | |
| tree | d758e1c8d9ee859be127e923e7b174638cc0a8b2 /controller | |
| parent | 90801a94d3febd8e77a785a396b3223d4a7d31c3 (diff) | |
| download | infinitytier-13b39a0c3e11ae44277599dc01512d620197b407.tar.gz infinitytier-13b39a0c3e11ae44277599dc01512d620197b407.zip | |
SQLite perf tuning
Diffstat (limited to 'controller')
| -rw-r--r-- | controller/SqliteNetworkController.cpp | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/controller/SqliteNetworkController.cpp b/controller/SqliteNetworkController.cpp index 5055aded..fb565dcb 100644 --- a/controller/SqliteNetworkController.cpp +++ b/controller/SqliteNetworkController.cpp @@ -140,6 +140,9 @@ SqliteNetworkController::SqliteNetworkController(Node *node,const char *dbPath,c throw std::runtime_error("SqliteNetworkController cannot open database file"); sqlite3_busy_timeout(_db,10000); + sqlite3_exec(_db,"PRAGMA synchronous = OFF",0,0,0); + sqlite3_exec(_db,"PRAGMA journal_mode = MEMORY",0,0,0); + sqlite3_stmt *s = (sqlite3_stmt *)0; if ((sqlite3_prepare_v2(_db,"SELECT v FROM Config WHERE k = 'schemaVersion';",-1,&s,(const char **)0) == SQLITE_OK)&&(s)) { int schemaVersion = -1234; |