Hello all
As I was not able to find the information I have to ask here. Maybe it is
trivial.
In which order should VACUUM, INTEGRITY_CHECK and OPTIMIZE be executed? I have
been using this one so far but I am not sure about the latter two.
For the OPTIMIZE the documentation states: "... run just before closing each
database connection ...". There isn't a reason to do it instead after opening a
connection each time?
Thanks in advance for any feedback.
Cheers, Mischl
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users