SQLite Forum

Question on internals: Sync between WAL and B Tree
Login
> Then you would end up making the changes again? If I am incrementing a column, wouldn't that get incremented twice?

When the WAL is applied to the same db N times, it overwrites/replaces the same records each time. The end effect is as if it had been applied one time, even if it's physically applied two or more times.