From 6b5c87d5c35ebbac6f7fbcac1a722bd0b3148e04 Mon Sep 17 00:00:00 2001 From: Michaël Ball Date: Sun, 9 Aug 2015 14:44:55 +0100 Subject: Improve performance - introduce transactions --- models/track.py | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'models/track.py') diff --git a/models/track.py b/models/track.py index 854b3ee..8b16d26 100644 --- a/models/track.py +++ b/models/track.py @@ -72,6 +72,8 @@ class Track: db = DbManager() c = db.cursor() + c.execute("BEGIN TRANSACTION") + artist_names = metadata["artist"] musicbrainz_artist_ids = [] artistsorts = [] @@ -257,6 +259,8 @@ class Track: except apsw.ConstraintError: pass + c.execute("COMMIT TRANSACTION") + return True def save(self): @@ -334,6 +338,8 @@ class Track: db = DbManager() c = db.cursor() + c.execute("BEGIN TRANSACTION") + artist_names = metadata["artist"] musicbrainz_artist_ids = [] artistsorts = [] @@ -530,4 +536,6 @@ class Track: except apsw.ConstraintError: pass + c.execute("COMMIT TRANSACTION") + return True -- cgit v1.2.3