Comment on SQLite performance tuning: concurrent reads, multiple GBs and 100k SELECTs/sComments−yencabulator3yNormal is still completely corruption safe in WAL mode, and means only WAL checkpoints have to wait for FSYNC.I would consider data loss on crash to be "corruption", for sure. And synchronous=normal + journal_mode=WAL can lose data:https://www.sqlite.org/pragma.html#pragma_synchronousA transaction committed in WAL mode with synchronous=NORMAL might roll back following a power loss or system crash.
Comments
I would consider data loss on crash to be "corruption", for sure. And synchronous=normal + journal_mode=WAL can lose data:
https://www.sqlite.org/pragma.html#pragma_synchronous