Groups
Groups
Sign in
Groups
Groups
comp.databases.informix
Conversations
About
Send feedback
Help
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Learn more
Sequences & Locks
37 views
Skip to first unread message
tom...@gmail.com
unread,
Nov 6, 2012, 2:12:32 PM
11/6/12
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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 PM
11/13/12
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
AFAIK there should be no locking issues with sequences.
one could also look at serial(4 or 8)
Superboer
0 new messages