[tahoe-dev] configuring sqlite efficiency and durability

[Greg Troxel]

I know you don't want to use postgresql for real, probably, but it would
be interesting to have a choice of databases to see what the effects
are.

  So in short, I'm in favor of using synchronous=NORMAL,
  journal_mode=WAL for all current uses of sqlite in Tahoe-LAFS. Let me
  know if you see a flaw in this reasoning!

No real flaw, but did you consider batching things with transactions, so
that lease updates in blocks can be durable?
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 194 bytes
Desc: not available
URL: <http://tahoe-lafs.org/pipermail/tahoe-dev/attachments/20121203/18f66af6/attachment.pgp>