Re: Rollback on a Transaction with No Updates

2007-09-19 Thread Baron Schwartz
Robert DiFalco wrote: Is there any difference between calling rollback or commit on a transaction that did not alter data? For example, not a read-only transaction but a transaction that only performed read-only selects. Any difference in performance between calling rollback or commit? I know the

RE: Rollback on a Transaction with No Updates

2007-09-18 Thread Robert DiFalco
[mailto:[EMAIL PROTECTED] Sent: Tuesday, September 18, 2007 10:00 AM To: Robert DiFalco Cc: Baron Schwartz; mysql@lists.mysql.com Subject: Re: Rollback on a Transaction with No Updates I realize that wasn't the question, but it does seem like a lot of trouble to get the equivalent of setAutoCommit

Re: Rollback on a Transaction with No Updates

2007-09-18 Thread Michael Dykman
ichael Dykman [mailto:[EMAIL PROTECTED] > Sent: Monday, September 17, 2007 2:56 PM > To: Robert DiFalco > Cc: Baron Schwartz; mysql@lists.mysql.com > Subject: Re: Rollback on a Transaction with No Updates > > If your transaction are only 1 query deep, why use them at all? An > indivi

RE: Rollback on a Transaction with No Updates

2007-09-17 Thread Robert DiFalco
Sure, but that wasn't really the question. -Original Message- From: Michael Dykman [mailto:[EMAIL PROTECTED] Sent: Monday, September 17, 2007 2:56 PM To: Robert DiFalco Cc: Baron Schwartz; mysql@lists.mysql.com Subject: Re: Rollback on a Transaction with No Updates If your transa

Rollback on a Transaction with No Updates

2007-09-17 Thread Robert DiFalco
Is there any difference between calling rollback or commit on a transaction that did not alter data? For example, not a read-only transaction but a transaction that only performed read-only selects. Any difference in performance between calling rollback or commit? I know they are functionally the s

Re: Rollback on a Transaction with No Updates

2007-09-17 Thread Michael Dykman
same as issuing a commit (unless there was an exception but I'm not > analyzing that case). > > -Original Message- > From: Baron Schwartz [mailto:[EMAIL PROTECTED] > Sent: Monday, September 17, 2007 2:36 PM > To: Robert DiFalco > Cc: mysql@lists.mysql.com >

RE: Rollback on a Transaction with No Updates

2007-09-17 Thread Robert DiFalco
ing a commit (unless there was an exception but I'm not analyzing that case). -Original Message- From: Baron Schwartz [mailto:[EMAIL PROTECTED] Sent: Monday, September 17, 2007 2:36 PM To: Robert DiFalco Cc: mysql@lists.mysql.com Subject: Re: Rollback on a Transaction with No Updat

Re: Rollback on a Transaction with No Updates

2007-09-17 Thread Baron Schwartz
Robert DiFalco wrote: Is there any difference between calling rollback or commit on a transaction that did not alter data? For example, not a read-only transaction but a transaction that only performed read-only selects. Any difference in performance between calling rollback or commit? I know the