On 11/25/2010 09:04 PM, Simon Slavin wrote: > > 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.
If you use synchronous=FULL then it should not be possible to lose a transaction once it has been committed (assuming the hard disk is playing fair). Of course, that means a sync at the end of each transaction. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users