Mark,

You have asked a multi-dimensional question in a single dimensional manner
and forum.  If you want a comparative answer then you need to crosspost to
c.d.o (perhaps you have and I didn't see it).  You also need to call out
details of the transactions in question - hardware, volume, rowcount,
interface.  One cannot offer an answer to such a topic without qualifying it
with respect to these dimensions.  Sure I drive my car at 100, but is that
KPH or MPH?  That is half of the reason behind the Oracle license (though
shalt not publish benchmarks) - the other half is, of course, DBA skill.

I cannot answer the clients basic question.  It may very well make sense for
them to move to Oracle, or not.  In my years of dealing with this sort of
situation, I have yet to see it come down to technical details.  That in and
of itself may be telling enough.

Regards,
Jack Parker

-----Original Message-----
From: informix-list-bounces@iiug.org
[mailto:informix-list-bounces@iiug.org]On Behalf Of
mark.scranton@gmail.com
Sent: Monday, January 28, 2008 8:54 PM
To: informix-list@iiug.org
Subject: Re: TPS

On Jan 28, 4:46 pm, "Jack Parker" <jack.park...@verizon.net> wrote:

One-sided? How's that Jack? Perhaps I wanted to see if anyone had such
numbers for a current client that is in the midst of the "should be
move to Oracle" battle. Strange response to my post no doubt...

Mark

_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list

Mark, then why don't you actually say something to that effect?

You say "Hey! anyone doing fast OLTP in Oracle and Informix?" And the answer is yes.
They someone else gives some more detail but doesn't really say what is going on and is asking for information that hey! I can't give due to NDAs.

If you had asked the question :"Hey! I have a situation where the customer is facing a request to migrate to Oracle and I'm wondering about a comparison to Oracle..." Then I could have given you a pat answer.

The answer to your question is the following:
Yes, you can migrate to Oracle.
You will have to spend more on hardware to get the performance you require.
You will have to spend more on staff to maintain the engine.
You will have to spend more money on upgrades to your hardware if you want to scale.

BUT, YOU HAVE TO CONSIDER THAT THIS MIGRATION IS FOR A ZERO NET GAIN IN EITHER FEATURES AND FUNCTIONALITY. YOU WILL INCUR RISK AND EXPENSE FOR NO NET NEW FEATURES.

Which will tell you that you don't want to migrate.

NOTE: Because Daniel is here and I do work with multiple databases...
THE LAST FACT IS TRUE IF YOU'RE GOING FROM ORACLE TO INFORMIX. You *will* incur expense and risk with no net gain in features, therefore you have to have a compelling reason to switch databases.
(We're talking about an apples to apples migration)

Does that make sense?
So what you need to do is to identify the person asking for the migration and determine the compelling reason for the switch.
THEN ADDRESS THAT!

_________________________________________________________________
Helping your favorite cause is as easy as instant messaging. You IM, we give.
http://im.live.com/Messenger/IM/Home/?source=text_hotmail_join