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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
