Actually, it can't be in a transaction. To quote: "A VACUUM will fail if there is an open transaction, or if there are one or more active SQL statements when it is run." (See http://www.sqlite.org/lang_vacuum.html).
Best regards, Peter ________________________________ From: Pete <p...@mollysrevenge.com> To: sqlite-users@sqlite.org Sent: Mon, March 26, 2012 10:14:32 AM Subject: Re: [sqlite] VACUUMing large DBs SHould a VACUUM command be wrapped in a transaction, or is that done automatically? -- Pete _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users