3 ms·

What does that do? How is VACUUM different from BACKUP in this context?

• smitty1e 5y ago
  "The VACUUM command with an INTO clause is an alternative to the backup API for generating backup copies of a live database. The advantage of using VACUUM INTO is that the resulting backup database is minimal in size and hence the amount of filesystem I/O may be reduced. Also, all deleted content is purged from the backup, leaving behind no forensic traces. On the other hand, the backup API uses fewer CPU cycles and can be executed incrementally." https://sqlite.org/lang_vacuum.html https://sqlite.org/lang_vacuum.html