Path: utzoo!attcan!uunet!lll-winken!brutus.cs.uiuc.edu!apple!oracle!news From: csimmons@jewel.oracle.com (Charles Simmons) Newsgroups: comp.arch Subject: Re: 64-bit addresses Message-ID: <1990Mar6.081115.447@oracle.com> Date: 6 Mar 90 08:11:15 GMT References: <783@dgis.dtic.dla.mil> <1786@gannet.cl.cam.ac.uk> <1990Mar2.232735.6071@world.std.com> <780@dgis.dtic.dla.mil> <1990Mar4.222938.20483@world.std.com> Sender: news@oracle.com Reply-To: csimmons@oracle.com Organization: Oracle Corp Lines: 44 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