On 15 Jun 2017, at 5:07pm, Keith Medcalf <[email protected]> wrote: > > .backup makes a backup of the database file using the backup API call, > effectively copying all the pages (without looking at them to much) from main > to the new file.
However, I think this lacks one of the advantages of VACUUM: it won’t reclaim unused space in the pages it copies. The copy will be the same size as the original. If you’re absolutely certain that nobody else is accessing your database, I wonder whether some of the PRAGMAs might speed up VACUUM. Simon, _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
