Mercurial > hg > orthanc

comparison Core/SQLite/Connection.cpp @ 181:2dece1526c06

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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;");