Re: ROLLBACK vs COMMIT when nothing done

Posted in 1994

Colonel Panic — 28 Jul 1994 02:07:59 GMT — source: Informix-list mailing list archive (1991-1998)

In article <stuart.775183016@coral> stuart@coral.cs.jcu.edu.au (Stuart Kemp) writes: >Given the situation where you BEGIN WORK and shortly thereafter you >want to end the transaction *but nothing has been altered*, WRT efficiency >is it better to COMMIT or ROLLBACK? If you are sure nothing's been done that you don't want to keep, then COMMIT. Commit is the least amount of work. -- Alan Denney aland@informix.com {pyramid|uunet}!infmx!aland Disclaimer: Sender under influence of 1,3,7-trimethylxanthine