[odb-users] SQlite 3.24.0

[Andrew Cunningham]

This performance enhancement might be interesting for ODB developers using
SQLite

UPDATE avoids unnecessary low-level disk writes when the contents of the
database file do not actually change. For example, "UPDATE t1 SET x=25
WHERE y=?" generates no extra disk I/O if the value in column x is already
25. Similarly, when doing UPDATE on records that span multiple pages, only
the subset of pages that actually change are written to disk. This is a
low-level performance optimization only and does not affect the behavior of
TRIGGERs or other higher level SQL structures.

https://www.sqlite.org/releaselog/3_24_0.html