Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
From: David Williams <djw_at_smooth1.demon.co.uk>
Date: 1997/12/01
Message-ID: <G1qkBHA35fg0Ew6$_at_smooth1.demon.co.uk>#1/1
Date: 1997/12/01
Message-ID: <G1qkBHA35fg0Ew6$_at_smooth1.demon.co.uk>#1/1
In article <3481D92B.75AA9F0D_at_voicenet.com>, "Scott C. Gray"
<ickyspam_gray_at_voicenet.com> writes
>> page level locks give HIGHER PERFORMANCE yes BItUT the reduce
>> concurrency and hence LOWER RELIABILITY.
>
>Be careful with your wording...locking granularity has nothing at
>all to do with reliability (indeed, table locking vs. column locking
>has the same reliability when properly implemented). It is all
>simply a matter of concurrency and efficiency.
Most applications produce an error when a lock error occurs.
- Queries fails
- Database modifications produce an error and the transaction is rolled back (few applications retry).
Hence APPLICATION RELIABLITIY is reduce.
>-scott
>
-- David WilliamsReceived on Mon Dec 01 1997 - 00:00:00 CET