Fernando Nunes wrote:
> DA Morgan wrote:
>> Fernando Nunes wrote:
>>
>> Can anyone confirm the following statement is true?
>>
>> "Reads don't block writes and writes don't block reads and only
>> committed rows are visible."
>>
>
> Not absolutely sure, if the reader is in REPEATABLE READ/SERIALIZABLE...
> I will have to test it...
> But in the new isolation level writers won't block readers...
> The fact that Informix have been used in so many situations without this,
> would contradict the importance that you (and me) give to this
> feature...

And the fact that both SQL Server and Informix have quickly moved to add
this capability in the last 18 months would indicate otherwise.

IBM and Microsoft don't spend money implemented what doesn't matter.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)