> That depends. If the change was made using the same database > connection that was passed into sqlite3_backup_init(), then only those > pages that changed are recopied. However, if an independent database > connection made the change, then the backup process has no way of > knowing exactly which pages changed, so it has to start over again > from the beginning.
That makes sense, thank you. (I wasn't sure if the individual pages had a "Change Counter", similar to the one in the File Header, that could be used.) ~Eric _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users