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

Posted in 1997

David Williams — Mon, 1 Dec 1997 00:01:59 +0000 — source: Informix-list mailing list archive (1991-1998)

In article <3481D92B.75AA9F0D@voicenet.com>, "Scott C. Gray" <ickyspam_gray@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. 1. Queries fails 2. Database modifications produce an error and the transaction is rolled back (few applications retry). Hence APPLICATION RELIABLITIY is reduce. >-scott > -- David Williams