summaryrefslogtreecommitdiff
path: root/sources/master/search.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sources/master/search.sql')
-rw-r--r--sources/master/search.sql6
1 files changed, 6 insertions, 0 deletions
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;