Add pragmas to make the sqlite stuff run a little faster.

2 files changed, 12 insertions, 0 deletions

diff --git a/sources/db/update_characters.rb b/sources/db/update_characters.rb
index 9d253d2..a729818 100755
--- a/sources/db/update_characters.rb
+++ b/sources/db/update_characters.rb
@@ -31,6 +31,12 @@ dir = ARGV[0] || '.'
 db = SQLite3::Database.new(dir + '/taginfo-db.db')
 db.results_as_hash = true
 
+db.execute("PRAGMA journal_mode  = OFF");
+db.execute("PRAGMA synchronous   = OFF");
+db.execute("PRAGMA count_changes = OFF");
+db.execute("PRAGMA temp_store    = MEMORY;");
+db.execute("PRAGMA cache_size    = 5000000;");
+
 #------------------------------------------------------------------------------
 
 regexes = [
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;