From e8bd31b15ee35d4089d5fbd1a865ad9dc4abaaa4 Mon Sep 17 00:00:00 2001
From: Jochen Topf <jochen@topf.org>
Date: Tue, 13 May 2014 22:33:23 +0200
Subject: Add pragmas to make the sqlite stuff run a little faster.

---
 sources/master/search.sql | 6 ++++++
 1 file changed, 6 insertions(+)

(limited to 'sources/master')

diff --git a/sources/master/search.sql b/sources/master/search.sql
index 6c45182..f8555a2 100644
--- a/sources/master/search.sql
+++ b/sources/master/search.sql
@@ -8,6 +8,12 @@
 
 .bail ON
 
+PRAGMA journal_mode  = OFF;
+PRAGMA synchronous   = OFF;
+PRAGMA count_changes = OFF;
+PRAGMA temp_store    = MEMORY;
+PRAGMA cache_size    = 5000000;
+
 ATTACH DATABASE '__DIR__/db/taginfo-db.db' AS db;
 
 DROP TABLE IF EXISTS ftsearch;
-- 
cgit v1.2.3