Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
From: Pablo Sanchez <pablo_at_sgi.com>
Date: 1997/11/27
Message-ID: <yutlny9bqyr.fsf_at_mew.corp.sgi.com>#1/1
Date: 1997/11/27
Message-ID: <yutlny9bqyr.fsf_at_mew.corp.sgi.com>#1/1
>>>>> "Anthony" == Anthony Mandic <no_sp.am_at_agd.nsw.gov.au> writes:
Anthony> Anthony> Except in the case where one user has one row locked with RLL Anthony> and another users want a summery of all rows including the Anthony> locked one. Then you have to introduce further mechanisms to Anthony> overcome this. But no lock, implies no problem and no further Anthony> complexity.
I believe that this is the case when one asks for serializability. The set should not be interrupted. An interesting question for folks to ponder (as well as myself) is what Informix does when you mix a user requesting serializability with say a user requesting consistent reads. What happens with lock conflicts.
-- Pablo Sanchez | Ph # (650) 933.3812 Fax # (650) 933.2821 pablo_at_sgi.com | Pg # (800) 930.5635 -or- pablo_p_at_pager.sgi.com ------------------------------------------------------------------------------- I am accountable for my actions. http://reality.sgi.com/pablo [ /Sybase_FAQ ]Received on Thu Nov 27 1997 - 00:00:00 CET