Re: LocalStatus as SQLlite

[Stewart Smith <stewart@xxxxxxxxxxxxxxxx>]

On Mon, 2008-03-31 at 10:16 -0500, John Goerzen wrote:
> First off, thank you for your continued work and persistence on this.
Not a problem - just maintaining what i find useful. mmmm... free
software.

> Referring back to the original thread [1], it looks like there may be a 
> couple of regressions:
> 
> 1) That we cannot use threading to simultaneously download multiple messages 
> in a single folder;

Yep. One possible way around this would be to add locking to LocalStatus
so that only one thread can use the object at once (but every other bit
of code can run in parallel).

> 2) That changes are not committed immediately after each change (but only at 
> the end of processing a folder)

Or every 100 flag changes.

This is intentional. Commit == fsync() - so it's a relatively expensive
operation. When there's been a lot of changes (e.g. marking lots of
mails as read... common for me on heavy traffic mailing lists), it's the
difference between being able to sync about 100/s and a lot more /sec...
and also reduces file system journal traffic and leaves more disk ops
(sync) for other apps you're probably running at the same time.

If you crash during this part of the sync, it'll just have to re-sync up
to 100 messages flags.. so I don't think it's much of an issue.


-- 
Stewart Smith (stewart@xxxxxxxxxxxxxxxx)
http://www.flamingspork.com/


-- 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)

iQIVAwUAR/H5mr3yNwHyU3DLAQIMug/9HS6sutyGxoriugEe5B7A/EeRuqFBAuHd
3ZScgyYFTbX422pkG7FfFgR4x3y3isD9GVduGWu0OArVA3DKh8LEM287KSnMQYTO
grgSb6zIOLlsOV8oJlek5srSBpexJW5Afnlzdl+KX8Xw8Q35VHlnQI481TTU9EQb
StRhcC4nLC2lyyHCZI/Nne67bONWf5Fi1Q8uW/RfoMKbSuz2Wffwc1qnuNGId2SZ
UG5AYZ/MQo/JpH4Yk1gxGD+SIQQqzagksksUGZeo8MdeX6Yjzw4a4BOtP0Me9QmV
LcqZCL8Sq2S2tDyVnhA1GyO6VOy6Ekc6ofCe2K+hHEsopuGoXWJERgvOBwoFauwc
i7FbCbs2smW4iaX484x/klWDbNgDDuV31uvyt3hz8plW/H2rNWz1edM9aOsNt3wc
0Ol8ORpX/WD57K0oe1+EoS3LbpyX4PpeKPEZgFlEdv8shP+v0z5kMiL/6k5+Uun6
Ojg+Ib/WJxNXdyupRZBqVJYMuCRzAGe6om0vaEDI9LMHjjVoDv/DnDz/JT4DX+vA
qwAHGjNkLutLWH7TeCXrhfF8rGWViFQeNgPEpwxkiQP5s0EgReA6v5le2OSma8WY
ogKJG68sEaoa7D+tgvSq4sK/5tkc/EUbaiI+fJHKYWkYo37x9R0UtLddV24gR2vl
CZZBSbKWs/s=
=W5HK
-----END PGP SIGNATURE-----