> BTW: > Is there any chance that in the future the wal mode > will avoid that the backup API will restart on DB > changes during the backup loop ? > Currently, even in wal mode, it does restart when changes > are detected while the backup is ongoing.
What happens if you open a read transaction on the source database before starting the backup? i.e. sqlite3_exec(pSource, "BEGIN; SELECT * FROM sqlite_master", 0, 0, 0); ... do backup ... sqlite3_exec(pSource, "COMMIT", 0, 0, 0); Does that help things any? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users