Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Sequences & Locks

37 views
Skip to first unread message

tom...@gmail.com

unread,
Nov 6, 2012, 2:12:32 PM11/6/12
to
Hello
We hit a table extensively (and with multi threaded) for a next key value to be returned and of course it is running into deadlocks, etc.

We are looking to move this to sequences - are there locks involved with sequences in a multi threading scenario?

thanks
tom

super...@t-online.de

unread,
Nov 13, 2012, 1:12:57 PM11/13/12
to
AFAIK there should be no locking issues with sequences.

one could also look at serial(4 or 8)

Superboer
0 new messages