[Chicago] auto incrementing - what options do we have?
szybalski at gmail.com
Fri Oct 10 19:08:34 CEST 2008
On Fri, Oct 10, 2008 at 11:43 AM, David Durham, Jr.
<david.durham.jr at gmail.com> wrote:
> 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.
So what would be the transaction isolation in this case? Is that
session option or do I change it only on first insert?
More information about the Chicago