Relay-Version: version B 2.10 5/3/83; site utzoo.UUCP
Path: utzoo!utgpu!water!watnot!watmath!clyde!cbatt!cwruecmp!hal!ncoast!allbery
From: allbery@ncoast.UUCP
Newsgroups: comp.databases
Subject: Re: Re.: Ingres vs Informix
Message-ID: <2180@ncoast.UUCP>
Date: Sun, 15-Mar-87 00:18:29 EST
Article-I.D.: ncoast.2180
Posted: Sun Mar 15 00:18:29 1987
Date-Received: Sun, 15-Mar-87 13:45:07 EST
References: <1207@ihlpf.ATT.COM> <143900001@tiger.UUCP>
Reply-To: allbery@ncoast.UUCP (Brandon Allbery)
Followup-To: comp.databases
Organization: Cleveland Public Access UNIX, Cleveland, OH
Lines: 22

As quoted from <143900001@tiger.UUCP> by authorplaceholder@tiger.UUCP.UUCP:
+---------------
| Ingres 5.0 may indeed be faster, but does anybody care about concurrency?
| 
| If so, the page/table level locking of Ingres will still disappoint you
| on the "speed" of multi-user operations requiring snap-shots of large
| tables.
+---------------

Informix 3.30 only locks single records (no table lock!); Informix-SQL only
locks records during UPDATE SQL statements, and the only shared lock is at
the table level.  I see no improvement here.

++Brandon
-- 
t'E Ir. <<Have you any idea what it takes to be an elf in this crazy world?>>
 ____   ______________
/    \ / __   __   __ \   Brandon S. Allbery	    <backbone>!ncoast!allbery
 ___  | /__> /  \ /  \    aXcess Co., Consulting    ncoast!allbery@Case.CSNET
/   \ | |    `--, `--,    6615 Center St. #A1-105 	   (...@relay.CS.NET)
|     | \__/ \__/ \__/    Mentor, OH 44060-4101     
\____/ \______________/   +1 216 974 9210