Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server

Posted in 1997

Snorri Bergmann — Wed, 26 Nov 1997 11:56:12 +0000 — source: Informix-list mailing list archive (1991-1998)

Chris Curvey wrote: [Snipped] > > 2) Use optimistic locking. (So users who have been typing in for hours > > get the message: Somebody else has modified this rec while you were > > working. Please try again). > > Okay, but under row level locking in this case, nobody would be able to > view the records in question while the other user spent hours and hours > typing. > This is not correct. In Informix everyone can read the record from the master table, bur no-one can select it for update. It's only locked exclusively between UPDATE and COMMIT. -Snorri -- Snorri Bergmann | Mail: snorri@strengur.is Strengur Consulting Engineers | WWW: http://www.strengur.is/ Armuli 7 | Phone: +354 550 9000 (9007 direct) 108 Reykjavik Iceland | Telefax: +354 550 9010