summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--server.js2
-rw-r--r--tools/purge.sql2
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);