diff options
| -rwxr-xr-x | sources/db/update_characters.rb | 6 | ||||
| -rw-r--r-- | sources/master/search.sql | 6 |
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; |