On 9 Jan 2019, at 2:01pm, spamh...@bluewin.ch wrote: > In which order should VACUUM, INTEGRITY_CHECK and OPTIMIZE be executed?
If you are in any situation where INTEGRITY_CHECK should be run, do not make any changes to the database (e.g. ANALYZE) first. Those changes might overwrite parts of the file that may show that the database was corrupt. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users