[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Omaha.pm] Autocommmit?



> Is there a best-practices approach to going one way or the 
> other? I'm trying to think of a situation where I wouldn't 
> want an autocommit.

Well, you can't AutoCommit any time you want to control transactions,
which would be any time you're doing multiple, related SQL operations.
e.g.: Only do these 5 SQL statements IF all 5 of them work. If any of
them fail, don't do ANY. In those cases, you need to explicitly control
commit's/rollback's in your program at the appropriate times.

In general I vote for AutoCommit off. I'd much rather accidentally NOT
commit something when my program is wrong than accidentally commit
something I didn't mean to commit yet. The opposite is also arguable.

j