docsrc commit 3540d671bcc4835c removed one mention of NORMAL being the default synchronous mode while in WAL journalling mode, but several others remain:
* "FULL is the usual default setting when not in WAL mode." * "NORMAL is the default when in WAL mode." For the record, I think the real fix here is to change the behavior so it matches the documentation. It would be super-nice to be able to set WAL mode and automatically get high performance. I think a NORMAL default serves much better the majority of sqlite-using applications. (Typically, '5s window of uncertain durability on power loss' vs '>10x slowdown on all writes all the time') On a related note, how is SQLITE_DISABLE_DIRSYNC related to synchronous=EXTRA? I thought sqlite already synced the directory, given that compilation option's description.
