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

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_at_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