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:");