On 2/8/19, David Raymond <david.raym...@tomtom.com> wrote: > So to make sure I'm understanding it ok, with the new vacuum into command, > if I'm the only user of a file, then the sequence... > > open file1 > vacuum into file2 > close file1 > delete file1 > rename file2 to file1 > > ...is going to be potentially more than twice as fast as the old...
Think you will be hard-pressed to get a 2x performance increase. Faster, yes. 2x faster, I'm doubtful. But perhaps I'm wrong. Please try it and see and report back. > > open file1 > vacuum > > ...as it saves the whole re-write of the original file, along with all the > rollback journal or wal writes that entails. Correct? > > (With of course the whole "make sure it actually finished and didn't just > die" caveats before doing the delete and rename) > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users