I've got synchronous = off as the main one. Once in a while I'm tempted for journal_mode = off as well but that's just a little too risky for me, and making a copy to vacuum with it off would be about the same as having it on anyway. Apart from those nothing jumps out as a time saver, either pragmas or compile options.
-----Original Message----- From: sqlite-users [mailto:[email protected]] On Behalf Of Simon Slavin Sent: Thursday, June 15, 2017 1:46 PM To: SQLite mailing list Subject: Re: [sqlite] Expedited vacuum tool? 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 _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
