3 ms·
There is also VACUUM INTO: https://www.sqlite.org/lang_vacuum.html#vacuuminto https://www.sqlite.org/lang_vacuum.html#vacuuminto
by nikeee 4y ago
There is also VACUUM INTO:
https://www.sqlite.org/lang_vacuum.html#vacuuminto https://www.sqlite.org/lang_vacuum.html#vacuuminto
- nbevans 4y agoIndeed and in my experience this has been more reliable/predictable than the official backup API. The official backup API can get "stuck" on a very large and hot database because it, essentially, has to start from scratch if a page is modified. VACUUM INTO doesn't have this problem.