[tahoe-dev] configuring sqlite efficiency and durability

[David-Sarah Hopwood]

On 04/12/12 02:13, Zooko Wilcox-O'Hearn wrote:
> Write-Ahead Logging:
> 
> http://www.sqlite.org/wal.html
> 
> the "synchronous" setting:
> 
> http://www.sqlite.org/pragma.html#pragma_synchronous
> 
> The results are interesting. All numbers here are the total wall-clock
> time to run that unit test which adds-or-renews leases 3240 times:
> 
> synchronous = FULL (default), journal mode = default (rollback
> journal), time: 1042.4 seconds
> 
> synchronous = FULL (default), journal mode = WAL, time: 308.5 seconds
> 
> synchronous = OFF, journal mode = default (rollback journal), time
> (best of 5 runs): 14.9 seconds
> 
> synchronous = OFF, journal mode = WAL, best of 5 runs: 18.1 seconds
> 
> synchronous = NORMAL, journal mode = WAL, best of 5 runs: 19.7 seconds

Did you measure synchronous = NORMAL, journal mode = default?
It's unclear from the other cases whether that would be faster or slower
than synchronous = NORMAL, journal mode = WAL.

-- 
David-Sarah Hopwood ⚥

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 554 bytes
Desc: OpenPGP digital signature
URL: <http://tahoe-lafs.org/pipermail/tahoe-dev/attachments/20121204/ee7b0f22/attachment.pgp>