Use begin immediate transactions.

2 files changed, 2 insertions, 2 deletions

diff --git a/server.js b/server.js
index c685084..0a4d80d 100644
--- a/server.js
+++ b/server.js
@@ -66,7 +66,7 @@ var game_cookies = {}
 let db = new sqlite3(process.env.DATABASE || "./db")
 db.pragma("synchronous = NORMAL")
 
-const SQL_BEGIN = db.prepare("begin")
+const SQL_BEGIN = db.prepare("begin immediate")
 const SQL_COMMIT = db.prepare("commit")
 const SQL_ROLLBACK = db.prepare("rollback")
 
diff --git a/tools/purge.sql b/tools/purge.sql
index 3e0c898..add6e2d 100644
--- a/tools/purge.sql
+++ b/tools/purge.sql
@@ -26,7 +26,7 @@ create temporary view prune_all_list as
 		)
 	;
 
-begin;
+begin immediate;
 
 select 'PURGE SNAPS FROM ' || count(1) from prune_snap_list;
 delete from live.game_snap where game_id in (select game_id from prune_snap_list);