diff options
-rw-r--r-- | server.js | 2 | ||||
-rw-r--r-- | tools/purge.sql | 2 |
2 files changed, 2 insertions, 2 deletions
@@ -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); |