> Is there a reason SQLite doesn't ... update the change counter ... in WAL mode? Yes. WAL mode does not use the change counter. And updating the change counter involves extra code, extra CPU cycles, and extra I/O. So SQLite is smaller and runs faster without WAL-mode change counter updates.