[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.

-Dave


More information about the Chicago mailing list