From: Stewart Smith <stewart@willster.(none)>
Date: Mon, 31 Mar 2008 01:26:27 +0000 (+1100)
Subject: Commit ever 100 updateflags requests
X-Git-Url: https://code.delx.au/offlineimap/commitdiff_plain/4377cb3d2f7c73b6bc4663998df5ab0af833a6da

Commit ever 100 updateflags requests

Improves syncing large status changes by about a factor of 100

100 is arbitrary. Seems like an acceptable number to have to redo
if crash
---

diff --git a/offlineimap/folder/LocalStatus.py b/offlineimap/folder/LocalStatus.py
index 90ad3c8..86738b0 100644
--- a/offlineimap/folder/LocalStatus.py
+++ b/offlineimap/folder/LocalStatus.py
@@ -41,6 +41,7 @@ class LocalStatusFolder(BaseFolder):
         self.savelock = threading.Lock()
         self.doautosave = 1
         self.accountname = accountname
+        self.count = 0 # used for batching operations before commit
         BaseFolder.__init__(self)
 	self.dbfilename = self.filename + '.sqlite'
 
@@ -184,7 +185,10 @@ class LocalStatusFolder(BaseFolder):
         flags.sort()
         flags = ''.join(flags)
         self.cursor.execute('UPDATE status SET flags=? WHERE id=?',(flags,uid))
-        self.autosave()
+        self.count = self.count + 1
+        if self.count == 100:
+            self.autosave()
+            self.count = 0
 
     def deletemessage(self, uid):
         if not self.uidexists(uid):