On 19 Feb 2020, at 4:36pm, Olivier Mascia <[email protected]> wrote: > having an apparently sane database (pragma integrity_check and pragma > foreign_key_check successful at least), it would make sense to do : REINDEX, > ANALYZE and then VACUUM as part of final preparation step for archive (the DB > would be seldom queried later).
That would seem to the a good order in which to do those five things. If I was setting up a new system for customer use, I would give them a maintenance procedure which did those things, let them run it whenever they wanted, but tell them to run it at least once a year. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
