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

Posted in 1997

Pablo Sanchez — 01 Dec 1997 17:09:44 -0700 — source: Informix-list mailing list archive (1991-1998)

>>>>> "David" == David Williams <djw@smooth1.demon.co.uk> writes: David> David> In article <yutg1ocae6m.fsf@mew.corp.sgi.com>, Pablo Sanchez David> <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. David> David> Hence as in my other posting tonight page level can be slower David> due to more deadlocks!!! David> But that's unproven that you get more deadlocks with row level vs. page level... -- 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 ]