Non-scientific "let's just try it" results Short version: Original file had been vacuumed already as the last thing that had happened to it. File size: 20,467,359,744
sqlite> vacuum into 'vac_into.sqlite'; Run Time: real 589.577 user 222.941029 sys 57.829571 sqlite> vacuum; Run Time: real 1429.063 user 236.325915 sys 199.322478 Synchronous was off, journal mode was normal rollback journal. Was using the computer for normal work while doing it, but nothing else was using the physical drive these were on. Resulting files were the exact same size as the originals (it had been previously vacuumed as mentioned) -----Original Message----- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Richard Hipp Sent: Friday, February 08, 2019 11:29 AM To: SQLite mailing list Subject: Re: [sqlite] Vacuum into 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 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users