[qet] [2817] Optimizes cache_db_ for faster

[subversion@xxxxxxxxxxxxx]

Revision: 2817
Author:   scorpio810
Date:     2014-02-07 08:04:27 +0100 (Fri, 07 Feb 2014)
Log Message:
-----------
Optimizes cache_db_ for faster

Modified Paths:
--------------
    trunk/sources/elementscollectioncache.cpp

Modified: trunk/sources/elementscollectioncache.cpp
===================================================================
--- trunk/sources/elementscollectioncache.cpp	2014-02-06 23:55:02 UTC (rev 2816)
+++ trunk/sources/elementscollectioncache.cpp	2014-02-07 07:04:27 UTC (rev 2817)
@@ -39,10 +39,12 @@
 	if (!cache_db_.open()) {
 		qDebug() << "Unable to open the SQLite database " << database_path << " as " << connection_name << ": " << cache_db_.lastError();
 	} else {
-		cache_db_.exec("PRAGMA temp_store=MEMORY");
+		cache_db_.exec("PRAGMA temp_store = MEMORY");
 		cache_db_.exec("PRAGMA journal_mode = MEMORY");
-		cache_db_.exec("PRAGMA synchronous=OFF");
-		cache_db_.exec("PRAGMA cache_size=10000");
+		cache_db_.exec("PRAGMA page_size = 4096");
+		cache_db_.exec("PRAGMA cache_size = 16384");
+		cache_db_.exec("PRAGMA locking_mode = EXCLUSIVE");
+		cache_db_.exec("PRAGMA synchronous = OFF");
 		/// @todo the tables could already exist, handle that case.
 		cache_db_.exec("CREATE TABLE names (path VARCHAR(512) NOT NULL, locale VARCHAR(2) NOT NULL, mtime DATETIME NOT NULL, name VARCHAR(128), PRIMARY KEY(path, locale));");
 		cache_db_.exec("CREATE TABLE pixmaps (path VARCHAR(512) NOT NULL UNIQUE, mtime DATETIME NOT NULL, pixmap BLOB, PRIMARY KEY(path), FOREIGN KEY(path) REFERENCES names (path) ON DELETE CASCADE);");