Hi, >>> 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). Is there any way to force a sync to disk (e.g. that I could call every few seconds), other than PRAGMA wal_checkpoint ?
Regards, Twylite _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users