Mercurial > hg > orthanc

comparison OrthancServer/DatabaseWrapper.cpp @ 374:42e87c17cab8

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
some refactoring
author Sebastien Jodogne <s.jodogne@gmail.com>
date Mon, 15 Apr 2013 17:00:26 +0200
parents 6ab6cdeedf4e
children 4d5f0857ec9c
comparison
equal deleted inserted replaced
373:7000726bade7 374:42e87c17cab8
748 Open(); 748 Open();
749 } 749 }
750 750
751 void DatabaseWrapper::Open() 751 void DatabaseWrapper::Open()
752 { 752 {
753 // Performance tuning of SQLite with PRAGMAs
754 // http://www.sqlite.org/pragma.html
755 db_.Execute("PRAGMA SYNCHRONOUS=NORMAL;");
756 db_.Execute("PRAGMA JOURNAL_MODE=WAL;");
757 db_.Execute("PRAGMA LOCKING_MODE=EXCLUSIVE;");
758 db_.Execute("PRAGMA WAL_AUTOCHECKPOINT=1000;");
759 //db_.Execute("PRAGMA TEMP_STORE=memory");
760
753 if (!db_.DoesTableExist("GlobalProperties")) 761 if (!db_.DoesTableExist("GlobalProperties"))
754 { 762 {
755 LOG(INFO) << "Creating the database"; 763 LOG(INFO) << "Creating the database";
756 std::string query; 764 std::string query;
757 EmbeddedResources::GetFileResource(query, EmbeddedResources::PREPARE_DATABASE); 765 EmbeddedResources::GetFileResource(query, EmbeddedResources::PREPARE_DATABASE);