On Wed, Jun 30, 2010 at 1:21 PM, D. Richard Hipp <d...@hwaci.com> wrote:
> We are in the final phases of development for SQLite version 3.7.0.
> The key enhancement over version is support for the use of
> write-ahead logs for transaction control.  See 
> http://www.sqlite.org/draft/wal.html
>  for additional information on how this might enhance your  use of
> SQLite.

For reference, I've got an embedded application (Linux/UBIFS on NAND)
that's write-heavy, and which has been pretty well optimized for
SQlite performance.  I replaced the library with the latest snapshot
and set journal_mode=WAL, no further tweaking of checkpointing or
anything, and log performance improved by ~30%.

Looking forward to 3.7.0!

Matthew L. Creech
sqlite-users mailing list

Reply via email to