On 25 Nov 2010, at 2:00pm, Dan Kennedy wrote:

> In WAL mode with synchronous=NORMAL, when the user commits
> a transaction, it is written into the WAL file. No sync
> until a checkpoint happens. So if the power fails, you might
> lose all the transactions that have been written into the WAL
> file.

Ahha.  That explains it.  Thanks for that.  This makes WAL mode less attractive 
to me.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to