On 30.11.2010 11:50, Dan Kennedy wrote: > >> 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?
wow... what a trick! Using your hint I'm not able to reproduce any restarts! I can imagine what your hint does in wal mode, but without your input I would never came to that idea... :-) Thanks Dan! This makes the wal mode and backup API even more sexy. Marcus > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users