Home -> Usenet -> comp.databases.oracle -> Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server

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

From: Pablo Sanchez <pablo_at_sgi.com>
Date: 1997/12/01
Message-ID: <yutbtz0a9mf.fsf_at_mew.corp.sgi.com>#1/1 








>>>>> "David" == David Williams <djw_at_smooth1.demon.co.uk> writes:

David> 
David> In article <yutg1ocae6m.fsf_at_mew.corp.sgi.com>, Pablo Sanchez
David> <pablo_at_sgi.com> writes
>>>>>>> "David" == David Williams <djw_at_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_at_sgi.com              | Pg # (800) 930.5635   -or-   pablo_p_at_pager.sgi.com
-------------------------------------------------------------------------------
I am accountable for my actions.   http://reality.sgi.com/pablo [ /Sybase_FAQ ]


Received on Mon Dec 01 1997 - 00:00:00 CET












Original text of this message