From 86c50ac343d420f82e47457b46ee6709768a803e Mon Sep 17 00:00:00 2001 From: Stefan Huber Date: Wed, 15 Jan 2014 11:52:41 +0100 Subject: [PATCH] Speed up sqlite access --- dvr-db.py | 2 ++ 1 file changed, 2 insertions(+) diff --git a/dvr-db.py b/dvr-db.py index 3200118..21f8a18 100755 --- a/dvr-db.py +++ b/dvr-db.py @@ -20,6 +20,8 @@ class Database: self.fn = fn self.conn = sqlite3.connect(fn, timeout=60) self.conn.execute("PRAGMA foreign_keys = ON") + self.conn.execute("PRAGMA journal_mode = MEMORY") + self.conn.execute("PRAGMA synchronous = OFF") self.createSchema() def createSchema(self): -- 2.39.5