🚀 go-pugleaf

In article <783@dgis.dtic.dla.mil>, jkrueger@dgis.dtic.dla.mil (Jon) writes:
> But again, it's my belief that you're right, that dead whales generate
> more and faster i/o's.  But I have no DATA. TP1 would be better than
> nothing, but DebitCredit would be the beginning of real usefulness.
> Anyone have any DATA?  If TP1, results are meaningless without
> including information about table sizes used and method used to
> simulate users (tty vs. network vs. multiple concurrent batch).
> -- 
> Jonathan Krueger    jkrueger@dtic.dla.mil   uunet!dgis!jkrueger
> The Philip Morris Companies, Inc: without question the strongest
> and best argument for an anti-flag-waving amendment.

Here at Oracle, we run TP1s on lots of different platforms.  Currently
the Amdahl 5990 is the fastest TP1 machine.  [Hmmm...  Unless Amdahl
has announced something more recent than the 5990.]  A good industrial
strength mainframe can generate something on the order of 300 or so
transactions per second.  [It might be 250, it might be 400, I don't
remember the exact number.  But it isn't 1000, unless you cheat a lot.]

A good fast mini such as a Sequent with 20 or so processors can execute
on the order of 120 transactions per second.  I think you could get
a Sun 3/50 or 3/60 to do around 10 transactions per second.  For the
current generation of RISC workstations, 20-30 TPS is the figure to shoot for.

What kind of hardware do you need for high TPS rates?  Fast disks.
When we're doing performance analysis of a port, we play lots of little
games like using a real small database that fits in memory, etc.  On
a 5990, if your database fits in memory, and if you turn off logging
[Kids!  Don't try this at home!] you can get 1000 or so TPS.  But as
soon as you start doing I/O, your performance drops dramatically.

For example, the Apollo Prism (4 processors) can do around 120 TPS...as long
as you don't do any I/O.  Start doing I/O and the number drops to 30 or
40.  Also, EDASD helps your TPS rates a lot.

An interesting measure is cost per TPS.  A mainframe costs around
$50,000 per TPS.  A PC costs about $1,000 per TPS.

Currently, the various development groups around here are having a bit
of a contest to see who can put together the first machine to execute
1000 TPS (with I/O turned on).  The next goal will be to do 1000 TPS
at a cost of $1,000 per TPS.

-- Chuck