On 8/4/17, 1:59 PM, "sqlite-users on behalf of Nico Williams" <sqlite-users-boun...@mailinglists.sqlite.org on behalf of n...@cryptonector.com> wrote: > The checkpoint process would look like this: > - make a new file in the same directory > - copy the DB to the new file > - rename the new file into place > - write the "closed, renamed" marker into the old file (which is still open)
Step 2 seems rather expensive, even if you’re filtering out dead blocks in the process. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users