Mercurial > hg > orthanc
comparison Core/SQLite/Connection.cpp @ 181:2dece1526c06
simplifying db schema
author | Sebastien Jodogne <s.jodogne@gmail.com> |
---|---|
date | Fri, 09 Nov 2012 18:09:19 +0100 |
parents | 0e97abc7b950 |
children | 4453a010d0db |
comparison
equal
deleted
inserted
replaced
180:626777d01dc4 | 181:2dece1526c06 |
---|---|
87 | 87 |
88 // Execute PRAGMAs at this point | 88 // Execute PRAGMAs at this point |
89 // http://www.sqlite.org/pragma.html | 89 // http://www.sqlite.org/pragma.html |
90 Execute("PRAGMA FOREIGN_KEYS=ON;"); | 90 Execute("PRAGMA FOREIGN_KEYS=ON;"); |
91 | 91 |
92 Execute("PRAGMA RECURSIVE_TRIGGERS=ON;"); | |
93 | |
92 // Performance tuning | 94 // Performance tuning |
93 Execute("PRAGMA SYNCHRONOUS=NORMAL;"); | 95 Execute("PRAGMA SYNCHRONOUS=NORMAL;"); |
94 Execute("PRAGMA JOURNAL_MODE=WAL;"); | 96 Execute("PRAGMA JOURNAL_MODE=WAL;"); |
95 Execute("PRAGMA LOCKING_MODE=EXCLUSIVE;"); | 97 Execute("PRAGMA LOCKING_MODE=EXCLUSIVE;"); |
96 Execute("PRAGMA WAL_AUTOCHECKPOINT=1000;"); | 98 Execute("PRAGMA WAL_AUTOCHECKPOINT=1000;"); |