On 26 Mar 2012, at 6:14pm, Pete <[email protected]> wrote: > SHould a VACUUM command be wrapped in a transaction, or is that done > automatically?
All SQLite commands, even ones like SELECT which don't change anything, are actually executed inside a transaction. If you've already opened one yourself, SQLite uses that. If you haven't, SQLite begins a transaction, executes the command, then ends the transaction. So you don't have to bother. You can do just the VACUUM and SQLite will wrap it up for you. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
