Re: Rollback on a Transaction with No Updates

[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
>> they are functionally the same at the high level. 

I just thought of a difference.  If you are using LOCK TABLES and UNLOCK 
TABLES, these interact differently with COMMIT and ROLLBACK.  More info:

http://dev.mysql.com/doc/refman/5.0/en/lock-tables.html

Baron