On 8 Nov 2013, at 3:06pm, Mario M. Westphal <m...@mwlabs.de> wrote: > The first phase in my analysis checks the data in the database for logical > problems, business logic issues etc. > After this phase has been completed, my diagnosis function runs: > > 1. PRAGMA integrity_check(100) > 2. VACUUM > 3. ANALYZE
I would move just the integrity_check to before your business-logic check. And if that stage notices any problems, your program should abort there, since doing anything else to the database at that point will only mess it up further. If you want the ultimate in cleanness and neatness, ANALYZE should be before VACUUM, but it won't make that much difference. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users