Re: Let me be the first

Posted in 2006

Lukas Barton — Mon, 25 Sep 2006 17:40:27 +0200 — source: Usenet: comp.databases.informix

Obnoxio The Clown wrote: > Lukas Barton said: > >> Only row versioning may solve my problem. >> > > Or selecting the correct rows. > > It does not, because Informix locks also previous and next row in all indexes. So that the probability of locking rows that other user want to read is more than zero. Lukas

↪ replying to Lukas Barton

scottishpoet — 25 Sep 2006 09:08:58 -0700 — source: Usenet: comp.databases.informix

Lukas Barton wrote: > Obnoxio The Clown wrote: > > Lukas Barton said: > > > >> Only row versioning may solve my problem. > >> > > > > Or selecting the correct rows. > > > > > It does not, because Informix locks also previous and next row in all > indexes. So that the probability of locking rows that other user want to > read is more than zero. > > Lukas sounds to me like you are using page level locking rather than row level locking thats the only way I see informix locking rows other than the one you want to read