Sequences & Locks

Posted in 2012

Topics: Transactions, Locking & Isolation

tomcaml@gmail.com — Tue, 6 Nov 2012 11:12:32 -0800 (PST) — source: Usenet: comp.databases.informix

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

↪ replying to tomcaml@gmail.com

superboer7@t-online.de — Tue, 13 Nov 2012 10:12:57 -0800 (PST) — source: Usenet: comp.databases.informix

AFAIK there should be no locking issues with sequences. one could also look at serial(4 or 8) Superboer Am Dienstag, 6. November 2012 20:12:32 UTC+1 schrieb tom...@gmail.com: > 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