- Published on
Investigation · Part 14 of 20 · What survives a crash
SQLite WAL Mode: Fewer fsyncs, a Different Promise
In WAL mode, a SQLite commit with synchronous=FULL is one frame and one fdatasync, and with NORMAL it is no sync at all. I followed both with strace on my laptop, measured them, and quote what the documentation promises after an application crash and after a power loss.