Mercurial > hg > orthanc
comparison Core/SQLite/Connection.cpp @ 374:42e87c17cab8
some refactoring
author | Sebastien Jodogne <s.jodogne@gmail.com> |
---|---|
date | Mon, 15 Apr 2013 17:00:26 +0200 |
parents | 4453a010d0db |
children | bdd72233b105 |
comparison
equal
deleted
inserted
replaced
373:7000726bade7 | 374:42e87c17cab8 |
---|---|
86 } | 86 } |
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 | |
92 Execute("PRAGMA RECURSIVE_TRIGGERS=ON;"); | 91 Execute("PRAGMA RECURSIVE_TRIGGERS=ON;"); |
93 | |
94 // Performance tuning | |
95 Execute("PRAGMA SYNCHRONOUS=NORMAL;"); | |
96 Execute("PRAGMA JOURNAL_MODE=WAL;"); | |
97 Execute("PRAGMA LOCKING_MODE=EXCLUSIVE;"); | |
98 Execute("PRAGMA WAL_AUTOCHECKPOINT=1000;"); | |
99 //Execute("PRAGMA TEMP_STORE=memory"); | |
100 } | 92 } |
101 | 93 |
102 void Connection::OpenInMemory() | 94 void Connection::OpenInMemory() |
103 { | 95 { |
104 Open(":memory:"); | 96 Open(":memory:"); |