Appreciate if I will get clarification. If any of the point out of the scope of mailing list then please mark. Thanks a lot!!!
On Wed, Jul 31, 2013 at 6:53 PM, techi eth <techi...@gmail.com> wrote: > Thanks for answer. > > Let me put my query on point mentioned by comparing historic way of > doing copy at the start of link. > 1. "Any database clients wishing to write to the database file while a > backup is being created must wait until the shared lock is > relinquished." > > Example 1: Loading and Saving In-Memory Databases will not fulfill > this shortcoming. > > Example 2: Fulfill the shortcoming but cost of more time due to > restart of backup from fresh in the case of INSERT, ALTER, DROP & > UPDATE.I understand SELECT will not add time. > > Addinitionally what happen if other process is not able to complete > operation within timeout duration? > > 2. "It cannot be used to copy data to or from in-memory databases." > > I haven't got it full but I understand by CP I am able to copy any > file in Linux system. > > 3."If a power failure or operating system failure occurs while copying > the database file the backup database may be corrupted following > system recovery" > > This is very useful benefit. What is the resulted outcome of power > failure or OS failure if we use backup API? > > > > On 7/31/13, Simon Slavin <slav...@bigfraud.org> wrote: > > > > On 31 Jul 2013, at 12:56pm, techi eth <techi...@gmail.com> wrote: > > > >> I have followed below link for details. It say “If another thread or > >> process writes to the source database while this function is sleeping, > >> then > >> SQLite detects this and usually restarts the backup process when > >> sqlite3_backup_step() is next called”. > >> > >> - It means it will start back-up from start or resume from last left > page > >> but making sure all update will be written in backup file. > > > > Every time a change is made the backup has to restart from the beginning > > again. So if, for example, it would take 300 seconds to backup the > entire > > file, the backup process will not complete until there has been a 300 > second > > period when no changes were made to the file. > > > >> - Is their any issue if process acquiring database handle will do both > >> the > >> operation (Writing & Backup). > > > > No. This is not a problem. Though, of course, if anything does use that > > handle to write to the database the backup will be (automatically) > > restarted. > > > >> http://www.sqlite.org/backup.html > > > > Simon. > > _______________________________________________ > > 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