Use journal_mode=MEMORY

gwicke · gwicke · commit 88a449ad7226 · 2015-04-16T18:32:04.000-07:00
diff --git a/lib/sqlitestore.js b/lib/sqlitestore.js
@@ -9,6 +9,7 @@ var pragmas = [
     'PRAGMA main.locking_mode=EXCLUSIVE',
     'PRAGMA main.synchronous=OFF', // more dangerous, but fast
     'PRAGMA mmap_size=1099511627776',  // use fast mmap for entire db
+    'PRAGMA journal_mode=MEMORY',  // live risky but fast
     //'PRAGMA main.synchronous=NORMAL',
     //'PRAGMA main.journal_mode=WAL', // WAL is annoying for distributed files
 ];
