Re: Synchronization Issue (Folders not deleted)

[Stewart Smith <stewart@xxxxxxxxxxxxxxxx>]

Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable
On Wed, 2007-10-03 at 20:07 +0900, Bernhard Egger wrote:
> > I have a patch (see the archives, or i can send it to you) that uses a
> > sqlite database per folder for localstatus that *dramatically* speeds
> > this up and significantly reduces CPU time (i've been using it myself o=
n
> > my critical mail for several months now... so it does work).
> I would appreciate it if you could send it to me - thanks a lot.

Attached.

Apply in this order:
offlineimap_sqlite_localstatus.patch
updateflags_commit_every100.patch

The second one is just an improvement for syncing lots of changes to
message flags. In the event of crash, you may have to redo the sync of
up to 100 message flags, but this is fine, it just takes you a bit of
extra time/bandwidth/filesystem ops.

> > I'd be interested to hear you trying an initial sync with my patch and
> > see how it goes (should be a lot quicker too)
> well, the 300K messages folder does not contain that many messages any mo=
re
> (unfortunately). I just synched once to make a backup of my mail and then
> deleted it. I have about 5K messages in there now, and with my +/- 200 ju=
nk
> messages per day, it'll be quite big quite soon.
>=20
> Anyways, I'll try it out and then post the results.

It'll be a lot more noticable on 300k messages than 5k :)
--=20
Stewart Smith (stewart@xxxxxxxxxxxxxxxx)
http://www.flamingspork.com/



-- Binary/unsupported file stripped by Ecartis --
-- Type: text/x-patch
-- File: offlineimap_sqlite_localstatus.patch


-- Binary/unsupported file stripped by Ecartis --
-- Type: text/x-patch
-- File: updateflags_commit_every100.patch



-- Attached file included as plaintext by Ecartis --
-- File: signature.asc
-- Desc: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iQIVAwUARwRmv73yNwHyU3DLAQL6TBAAqREmDqvclrlnRZVAkJTuSsmUim4I03HQ
25/UnaMLUuLyAsJz37g4t5M+vyceaWY4kLkH8vDHLEJUB9ul+UfJzdiuE7Z9dEVA
tjcg91zPMU7r7BKx5aKSTsSPS4iwNBST4Wj6PCgvXbu3StJw1WvHEA5zJqj07Q6W
0WCXSHXaGvbJS00A05HqMwDDBA7gdSjhcXycgfDDWfSSBHmu006QiZqVbDiylTwk
BmQ28hYRrPj6gXF8jd68kKLFQR8RpGnZfEqb1lXt47x2+Vz/utcJ98nHr64iMYFi
n3CXPhd8etlu6L6rDJSlImzmokwPvrwCyL10KI3oJe9MzZIHYkhVaqNXGmiWfuJ5
SxPwheqgSpy1CmOQhdA8AQ5NsymUXiRA/FcgIshYi0QMARz/Kz8sNLwe63Rs5V15
wrsMs6WTQjJ0mLajh/Rrd0+2Z3HCK4LIrprwP59yXpjmEFyF93+9uI3VN3qDnODZ
cn+KsOP49hfWAJd/hZtehfUwJgHbncnwhhh2uiNPMxUx7VsbQy8hjLVjOq+oCh6D
9/C9XGnbisk65neyYYizrEnIYA5AVrPBU0RRlW3uckRE8MPp9tqjjW5QIXaRB4W0
0WajRVVb3b+zG4Njb4NjucwzTASLR9Z418andidikpQJo7ybvlfQFhecPVzFO1KP
glS3DeBXf5I=
=ejLr
-----END PGP SIGNATURE-----