SQLite Forum

Question about WAL Checkpoint process
Login
When SQLite start Checkpoint,is there a backup file create to avoid crash in between multi write into into main file?

for example if there need copy 1000 page into main file,  what happy if app crashed at write 999 page?

If they are create backup file and rename it late for atomic,  this will cause a lot IO for a huge database(for example 1TB database). Is this the case for SQLite?

I know there is batch-atomic-write to solve this problem, but that only work for F2FS.