create SQLite in WAL mode
2 files changed, 3 insertions(+), 0 deletions(-) M .hgignore M syslogd.py
M .hgignore +1 -0
M syslogd.py +2 -0
@@ 84,6 84,8 @@ class SyslogUDPServer: async def connect_to_sqlite(self): self.db = await aiosqlite.connect('syslog.db', loop=self.loop) + # Enable WAL mode for better write performance + await self.db.execute('PRAGMA journal_mode=WAL') await self.db.execute('''CREATE TABLE IF NOT EXISTS SystemEvents ( ID INTEGER PRIMARY KEY AUTOINCREMENT, Facility INTEGER,