Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!ncar!asuvax!anasaz!john
From: john@anasaz.UUCP (John Moore)
Newsgroups: comp.databases
Subject: Re: benchmarks
Keywords: TPC
Message-ID: <948@anasaz.UUCP>
Date: 30 Nov 89 15:16:02 GMT
References: <2715@infmx.UUCP>
Reply-To: john@anasaz.UUCP (John Moore)
Organization: Anasazi Inc, Phoenix AZ
Lines: 22

In article <2715@infmx.UUCP> bgolden@infmx.UUCP (Bernard Golden) writes:
]There has been some discussion in this group recently about the desire for a
]'real' (i.e., 'trustable') benchmark for database products.  One of the
]major complaints is that benchmarks with the same name (e.g., 'debit-credit')
]vary from test to test and therefore test results are not directly 
]comparable.

My company is currently developing a hotel reservation system - something
which has much more complex database activities than a debit-credit
benchmark, and has high performance needs (60 transactions per second
with 50,000 terminals). We developed a detailed benchmark to simulate
our application, and ran it on Oracle and Informix. We were able
to quite accurately predict the performance in our application FROM
THE DEBIT CREDIT benchmarks. What we did was analyze the DC benchmark
in terms of internal database operations. We then performed the same
analysis on our benchmark. We were then able to take the results from
the DC benchmark and apply it to a model of ours.
-- 
John Moore (NJ7E)           mcdphx!anasaz!john asuvax!anasaz!john
(602) 861-7607 (day or eve) long palladium, short petroleum
7525 Clearwater Pkwy, Scottsdale, AZ 85253
The 2nd amendment is about military weapons, NOT JUST hunting weapons!


Brought to you by Super Global Mega Corp .com