Path: utzoo!utgpu!jarvis.csri.toronto.edu!clyde.concordia.ca!uunet!samsung!zaphod.mps.ohio-state.edu!mips!prls!pyramid!unify!jwc From: jwc@unify.uucp (J. William Claypool) Newsgroups: comp.databases Subject: Re: Client/server processes and implementations Message-ID: Date: 20 Dec 89 22:03:50 GMT References: <1989Dec12.141904.4391@idt.unit.no> <13520008@hpisod2.HP.COM> Reply-To: jwc@unify.UUCP (J. William Claypool) Organization: Unify Corporation, Sacramento, CA, USA Lines: 38 In article <13520008@hpisod2.HP.COM> dhepner@hpisod2.HP.COM (Dan Hepner) writes: >From: jwc@unify.uucp (J. William Claypool) >> >>Quite the opposite. I was suggesting that such a transaction is not >>entirely atypical. As a result, row level locking IS required and there >>is more potential for contention in the lock management routines. >> >>Actually, the big problem with some DBMS systems is that there is a >>single insert point when extending a table. Hence the games some >>vendors have had to play with multiple history tables for TP1. > >The freedom to "play games with multiple history tables" is >being codified in TPC-A. Yes. However, TPC-A requires disclosure if the partitioning of the history table is not transparent to the application. It seems apparent from this that there was (and is) some objection to a non-transparent implementation. >The rationale seems to be that if the benchmark insisted on a single history >table, then most existing products would immediately become bottlenecked >at precisely that place. If there were justification for that >bottleneck being taken taken that seriously, it wasn't discovered. TPC is the same companies that will be running the benchmark and have an interest in the results. TPC-A was defined by all of these companies reaching a consensus. Surely, you can't expect that the resulting benchmark will have any aspects which pose a serious problem for any of the major participants. Yes, Unify Corporation is a TPC member. No, Unify 2000 does not bottleneck on the history table. No, this article is not the official opinion of Unify Corporation. -- Bill Claypool W. (916) 920-9092 |I know what I know if you know what I mean jwc@unify.UUCP H. (916) 381-4205 |------------------------------------------ ...!{csusac,pyramid}!unify!jwc | SCCA SFR Solo II 74 es 1984 CRX 1.5