Tweak SQLite parameters to try and make writes faster

Currently they are very slow! Batching writes is going to be needed
at some point, too.

1 files changed, 12 insertions, 0 deletions

diff --git a/morphcacheserver/artifact_database.py b/morphcacheserver/artifact_database.py
index 0da46c4..f893b49 100644
--- a/morphcacheserver/artifact_database.py
+++ b/morphcacheserver/artifact_database.py
@@ -37,6 +37,18 @@ class ArtifactDatabase(object):
     def __init__(self, database_file):
         self.db, self.paramstyle = yoyo.connections.connect(
             'sqlite:///' + database_file)
+
+        # SQLite is by default very slow to write due to fsync() calls. These
+        # settings make it faster, but at a slightly increased risk of data
+        # loss.
+        #
+        # See:
+        #  - https://sqlite.org/pragma.html#pragma_synchronous
+        #  - https://sqlite.org/pragma.html#pragma_journal_mode
+        cursor = self.db.cursor()
+        cursor.execute('PRAGMA journal_mode=WAL;')
+        cursor.execute('PRAGMA synchronous=NORMAL;')
+
         self.apply_migrations(self.migrations_dir())
 
     def migrations_dir(self):