diff options
Diffstat (limited to 'connect-better-sqlite3.js')
| -rw-r--r-- | connect-better-sqlite3.js | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/connect-better-sqlite3.js b/connect-better-sqlite3.js index 008114b..6574346 100644 --- a/connect-better-sqlite3.js +++ b/connect-better-sqlite3.js @@ -31,7 +31,7 @@ module.exports = function (session) { let db = new SQLite(db_path, options.mode); db.pragma("journal_mode = WAL"); db.pragma("synchronous = OFF"); - db.exec("CREATE TABLE IF NOT EXISTS "+table+" (sid PRIMARY KEY, expires INTEGER, sess TEXT)"); + db.exec("CREATE TABLE IF NOT EXISTS "+table+" (sid PRIMARY KEY, expires INTEGER, sess TEXT) WITHOUT ROWID"); db.exec("DELETE FROM "+table+" WHERE "+now()+" > expires"); db.exec("VACUUM"); db.exec("PRAGMA wal_checkpoint(TRUNCATE)"); |