Eric Grange wrote: >> No, this is what makes the backup restart. With a step size of -1, it >> would never restart. > > Hmm, given WAL mode, this brings another question: why the sqlite CLI does > not do that but uses 100 pages?
Because it's much older than WAL mode. > Is using a backup_step N parameter only useful if you want to provide some > progress indicator or pace the backup? (ie. pace I/O bandwidth ?) It's useful in rollback journal mode, where the backup reader would block any writers for a long time. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
