Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
Posted in 1997
>>>>> "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. -- Pablo Sanchez | Ph # (650) 933.3812 Fax # (650) 933.2821 pablo@sgi.com | Pg # (800) 930.5635 -or- pablo_p@pager.sgi.com ------------------------------------------------------------------------------- I am accountable for my actions. http://reality.sgi.com/pablo [ /Sybase_FAQ ]