Hi Lukas,

Are you saying that you have 1 composite index on col1, and col2 ?

Or are you saying that you have 1 index on col1 and 1 index on col2?


For that matter, currently how large is each of your indices?

Just trying to see if there is somethign else involved.

----- Original Message ----
From: Lukas Barton <lukas@cnawr.cz>
To: Informix-list@iiug.org
Sent: Monday, September 25, 2006 12:17:24 PM
Subject: Re: Let me be the first


- http://docs.rinet.ru/InforSmes/ch15/ch15.htm ( For an index, three
more locks are necessary--one lock for the accessed row, one for the row
before the accessed row, and one for the row after the accessed row)
Which version of IDS does this refer to?

In any event, I never realised I was this lucky before. <preen> Maybe I'll
enter the Lottery this weekend.
I use IDS 10.0 on Windows.
Here is statement sequention to demonstrate my problem:

Thread1:
UPDATE TABLE table1 SET col1=10 WHERE col2=15;
.... further processing for 10 minutes....


Thread2:
SELECT * FROM TABLE table1 WHERE col2=20;
(locked until thread1 finished).


There is index on col1 and col2.

Lukas

_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list