Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!cs.utexas.edu!usc!wuarchive!decwrl!ucbvax!ucdavis!csusac!unify!jwc From: jwc@unify.uucp (J. William Claypool) Newsgroups: comp.databases Subject: Re: Client/Server processes and implementations Keywords: Client Server Processes Message-ID: Date: 14 Dec 89 16:31:26 GMT References: <7114@sybase.sybase.com> <6895@sybase.sybase.com> <2184@kodak.UUCP> <375@xyzzy.UUCP> <510@xyzzy.UUCP> <936@anasaz.UUCP> <2762@infmx.UUCP> <=LD.=$#@unify.uucp> <2813@infmx.UUCP> Reply-To: jwc@unify.UUCP (J. William Claypool) Organization: Unify Corporation, Sacramento, CA, USA Lines: 30 In article <2813@infmx.UUCP> aland@infmx.UUCP (alan denney) writes: >In article <=LD.=$#@unify.uucp> jwc@unify.UUCP (J. William Claypool) writes: >>In article <2762@infmx.UUCP> aland@infmx.UUCP (alan denney) writes: >>>(For example, running multiple insert processes against the same table >>>with page mode locking in use is considered to be in poor taste :-]). > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ >>>In a normal transaction mix, however, these lock contentions are >>>atypical. >> >>Unless, for example, you have an application where every transaction >>does an insert into a history table. ;-) > >You mean, you would recommend the use of page mode locking in such >an application (constant history table inserts) ??? 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. Of course, if there are enough insert points for all of the active transactions, page locks may be entirely adequate. -- 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