Path: utzoo!utgpu!news-server.csri.toronto.edu!bonnie.concordia.ca!uunet!edat!brian
From: brian@edat.UUCP (brian douglass personal account)
Newsgroups: comp.databases
Subject: Re: Any TUXEDO users here?
Message-ID: <2382@edat.UUCP>
Date: 28 Jan 91 20:15:18 GMT
References: <DENAP.91Jan10122420@alta.sw.stratus.com| <2060009@hpcuhc.cup.hp.com|
Organization: Electronic Data Technologies, Inc., Las Vegas, NV
Lines: 79


(Dan Hepner) writes:
|
||I understand Oracle has an XA interface currently
||working, and Informix is rumored to have one in the wings.  This
||makes sense since Informix is ATT's product of choice.
|
|One interpretation of the recent announcements (and lack thereof)
|from RM vendors is that they all want to keep as wide a market
|as they can for their products.  This only makes sense.  As such,
|they can be expected to interface to any TM which shows promise
|to extend their market penetration.

Informix & Sybase announced at Uniforum endorsement for TransArcs OSF
TM.  So I guess this statement is right on the money.

||All the reading of literature and ad 
||material is fine, but now I want to do some hands on.  If desired,
||I will post a report of what I find to the net, or just e-mail to
||those who wish to hear if the response is less.
|
|I for one look forward to reading your posted experiences.
|
||IMHO Tuxedo and/or
||ITran for small 386/486 systems could have enormous impact for Unix
||on the Desktop and OLTP.  I can get 20TPS out of a 386 Compaq for
||about $20,000.  $1,000/TPS is an enormous reduction in
||price/performance versus typical OLTP systems running $7,000+/TPS.
|
|Careful.  There is no good transformation between "benchmarking TPS"
|and "TPS on some real application".  Further, there are no good
|transformations between the various kinds of "TPS".   What kind of 
|TPS are you reporting, (TPC-A? TPC-B? TP-1?), and how was it measured. 
|At best, these numbers are only comparable with similar results on
|other machines.  At worst, their information content is limited
|to a measurement of the cleverness and or sleaziness of the benchmarkers 
|who generated the numbers.

The application I am building mimics TP1 almost exactly.  I have
customers, I have accounts, I have deposit and withdrawl stations.
I do two or three updates, an insert, a commit and I'm done.  Other,
real world applications that must also do deletions, nested loops,
ad-hoc queries, and all those other things that RDBMS do so well
absolutley must be careful looking at numbers.  All the ad claims
in the world are just so many paper-airplanes in pre-production
until you define your application requirements, sit down with a
possible product and try it out in YOUR world.  And not some
company lab where everything is sanitized.  Numbers are good for
comparitive purposes, but always try it out on your turf.

As a side note, a fella at Wyse said they did some prelim
benchmarks on their new 9000 series using Informix Online doing
TP1.  Unaudited numbers are 40TPs/processor with 8 maximum with a
cost of about $1500/TPS.  Official numbers should be coming out
over the next few months.

||Since Tuxedo also supports 2-phase commit, low-cost
||High/Availability systems are now within reach.
||Brian Douglass			Voice: 702-361-1510 X311
|
|Careful. Very few "off the shelf" systems have good recovery
|mechanisms for such configurations, and it's easy to underestimate
|the difficulty.  Indeed, 2PC protocols can keep your database
|consistent, but they won't help get things started back up again
|when something goes down.
|
|Dan Hepner

Yep, so I've seen, and been told.  But this does seem to be
something the TMs are interested in implementing.  See an earlier
comment.


Brian Douglass			Voice: 702-361-1510 X311
Electronic Data Technologies	FAX #: 702-361-2545
1085 Palms Airport Drive	brian@edat.uucp
Las Vegas, NV 89119-3715
-- 
Brian Douglass			brian@edat.uucp