Re: Informix beats Oracle
Posted in 2007
Topics: Transactions, Locking & Isolation
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)
DA Morgan wrote: > IBM and Microsoft don't spend money implemented what doesn't matter. OK now that one is worth framing for me. Cheers Serge -- Serge Rielau DB2 Solutions Development IBM Toronto Lab
>From: DA Morgan <damorgan@psoug.org> >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. No you twit. Its so that those trapped on Oracle will now have an easier time seeing what a real database can do. Thus putting those hordes of Oracle DBAs out to pasture. :-) _________________________________________________________________ Make every IM count. Download Messenger and join the i'm Initiative now. It's free. http://im.live.com/messenger/im/home/?source=TAGHM_June07
DA Morgan wrote: > 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. Hopefully not... But we all have favorite features and our disagreements with the choices they make... I like this one very much, but I would gladly change some of the new features by others... -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...