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

Posted in 1997

David Williams — Mon, 1 Dec 1997 23:14:05 +0000 — source: Informix-list mailing list archive (1991-1998)

In article <yutg1ocae6m.fsf@mew.corp.sgi.com>, Pablo Sanchez <pablo@sgi.com> writes >>>>>> "David" == David Williams <djw@smooth1.demon.co.uk> writes: >David> >David> Correct, the user will receive an error message saying this item >David> cannot be updated an hence this "the application failed with an error, >David> it is not as reliable as other applications". > >Nope, the *smart* application programmer will resubmit the >query and hopefully it won't deadlock. You can have a >MAXRETRIES and then fail out... of course deadlocks are a >performance hit. Hence as in my other posting tonight page level can be slower due to more deadlocks!!! -- David Williams