13 ms·
https://sqlite.org/lang_vacuum.html https://sqlite.org/lang_vacuum.html
by audience_mem 6y ago
https://sqlite.org/lang_vacuum.html https://sqlite.org/lang_vacuum.html
- LockAndLol 6y agoThank you. So my intuition was correct about deletions creating non-contiguous data. I wonder how often VACUUM is run by fossil.
- mmcdermott 6y agoI'm no expert on the code, but vacuum comes up a lot when grepping the source. For example, it looks like it always runs vacuum after a remote clone (clone_cmd in https://www.fossil-scm.org/xfer/file?name=src/clone.c&ci=tip https://www.fossil-scm.org/xfer/file?name=src/clone.c&ci=tip) and after importing from another SCM (import_cmd in https://www.fossil-scm.org/xfer/file?name=src/import.c&ci=tip https://www.fossil-scm.org/xfer/file?name=src/import.c&ci=ti...).