[Chicago] auto incrementing - what options do we have?
David Durham, Jr.
david.durham.jr at gmail.com
Fri Oct 10 18:43:56 CEST 2008
On 10/10/08, Kumar McMillan <kumar.mcmillan at gmail.com> wrote:
> Actually, you might have to explicitly declare table level locks as
> opposed to row level locks. Most dbs support LOCK TABLES, i.e. for
> myql : http://dev.mysql.com/doc/refman/5.0/en/lock-tables.html which
> is what you want in this case.
Right, but locking is not the only way to ensure transaction
integrity. It's better to stick with simply setting transaction
isolation to what you need and letting the db deal with whether or not
it will use locking or something like MVCC.
More information about the Chicago