TPS
Not a bug report but a poll: Mark Scranton asked how many Informix (and Oracle) installations run at 500+ transactions per second, later explaining he needed ammunition for a client debating a migration to Oracle. Respondents complained the question was too vague without defining a "transaction" and the hardware/workload context, and argued an Informix-to-Oracle move brings cost and risk with no feature gain. Richard Kofler gave a concrete example of an IDS 10 system on tuned Linux with 96 CPU VPs, huge buffer pools and SSDs reaching close to 500 TPS. No single conclusion is recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Curious - Two questions - 1) How many of your ifmx engines are at 500 transactions per second or greater? 2) anyone have any oracle engines in that range? Thanks! Mark Scranton Xtivia Inc.
Yes and yes.But you have to better define what you consider a transaction.> From: mark.scranton@gmail.com> Subject: TPS> Date: Fri, 25 Jan 2008 15:09:35 -0800> To: informix-list@iiug.org> > Curious -> > Two questions -> > 1) How many of your ifmx engines are at 500 transactions per second or> greater?> > 2) anyone have any oracle engines in that range?> > Thanks!> Mark Scranton> Xtivia Inc.> _______________________________________________> Informix-list mailing list> Informix-list@iiug.org> http://www.iiug.org/mailman/listinfo/informix-list _________________________________________________________________ Climb to the top of the charts! Play the word scramble challenge with star power. http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_jan
I'm curious as to why anyone would request Oracle TPS numbers in an Informix group. I do not see a crosspost on this in c.d.o.. I would be suspicious of any conclusions drawn from answers to such an apparently one-sided question. cheers j. -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org]On Behalf Of mark.scranton@gmail.com Sent: Friday, January 25, 2008 6:10 PM To: informix-list@iiug.org Subject: TPS Curious - Two questions - 1) How many of your ifmx engines are at 500 transactions per second or greater? 2) anyone have any oracle engines in that range? Thanks! Mark Scranton Xtivia Inc. _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list
On Jan 28, 4:46 pm, "Jack Parker" <jack.park...@verizon.net> wrote: > I'm curious as to why anyone would request Oracle TPS numbers in an Informix > group. I do not see a crosspost on this in c.d.o.. I would be suspicious > of any conclusions drawn from answers to such an apparently one-sided > question. > > cheers > j. > > -----Original Message----- > From: informix-list-boun...@iiug.org > > [mailto:informix-list-boun...@iiug.org]On Behalf Of > mark.scran...@gmail.com > Sent: Friday, January 25, 2008 6:10 PM > To: informix-l...@iiug.org > Subject: TPS > > Curious - > > Two questions - > > 1) How many of your ifmx engines are at 500 transactions per second or > greater? > > 2) anyone have any oracle engines in that range? > > Thanks! > Mark Scranton > Xtivia Inc. > _______________________________________________ > Informix-list mailing list > Informix-l...@iiug.orghttp://www.iiug.org/mailman/listinfo/informix-list 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
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: > I'm curious as to why anyone would request Oracle TPS numbers in an Informix > group. I do not see a crosspost on this in c.d.o.. I would be suspicious > of any conclusions drawn from answers to such an apparently one-sided > question. > > cheers > j. > > -----Original Message----- > From: informix-list-boun...@iiug.org > > [mailto:informix-list-boun...@iiug.org]On Behalf Of > mark.scran...@gmail.com > Sent: Friday, January 25, 2008 6:10 PM > To: informix-l...@iiug.org > Subject: TPS > > Curious - > > Two questions - > > 1) How many of your ifmx engines are at 500 transactions per second or > greater? > > 2) anyone have any oracle engines in that range? > > Thanks! > Mark Scranton > Xtivia Inc. > _______________________________________________ > Informix-list mailing list > Informix-l...@iiug.orghttp://www.iiug.org/mailman/listinfo/informix-list 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! > From: mark.scranton@gmail.com > Subject: Re: TPS > Date: Mon, 28 Jan 2008 17:53:36 -0800 > To: informix-list@iiug.org > > On Jan 28, 4:46 pm, "Jack Parker" <jack.park...@verizon.net> wrote: > > I'm curious as to why anyone would request Oracle TPS numbers in an Informix > > group. I do not see a crosspost on this in c.d.o.. I would be suspicious > > of any conclusions drawn from answers to such an apparently one-sided > > question. > > > > cheers > > j. > > > > -----Original Message----- > > From: informix-list-boun...@iiug.org > > > > [mailto:informix-list-boun...@iiug.org]On Behalf Of > > mark.scran...@gmail.com > > Sent: Friday, January 25, 2008 6:10 PM > > To: informix-l...@iiug.org > > Subject: TPS > > > > Curious - > > > > Two questions - > > > > 1) How many of your ifmx engines are at 500 transactions per second or > > greater? > > > > 2) anyone have any oracle engines in that range? > > > > Thanks! > > Mark Scranton > > Xtivia Inc. > > _______________________________________________ > > Informix-list mailing list > > Informix-l...@iiug.orghttp://www.iiug.org/mailman/listinfo/informix-list > > 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 _________________________________________________________________ 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
mark.scranton@gmail.com schrieb: > Curious - > > Two questions - > > 1) How many of your ifmx engines are at 500 transactions per second or > greater? close to 500 - yes. This customer's transactions are counted at the application servers, though. So what might be a database TX? We know that on average 1 appTX does 4.1 commits The customer must run the database(s) in log mode ANSI. The app is (buf)read : (buf)write like 45 : 55. Using info posted later than my answer, I cannot judge if a comparison is possible. But some figures, which I hope I am allowed to post, as they are outdated meanwhile: IDS version is V10. Hardware is comparably cheap, but 'hand selected & assembled' -> NO 'big iron', NO AIX, NO SOL10 but a Linux Kernel where scheduler and I/O scheduler are non standard. The database server is NOT using FC-AL for I/O, but (2x) 4 x 10Gbit Ethernet. No switches are in the way. IDS runs with 96 CPUvps on _very_ fast threaded CPUs. Memory thruput is close to 80,000 2KB buffer attaches per CPUvp and second. This number is from synthetical benchmarks. We almost have no buffer contention. The pool is huuuge. DDR3 multilane memory is very fast. 3 different sizes of buffers are in use to keep contention as low as possible. Peak load is doing almost zero physical read I/O apart from physical I/O which is done on real SSDs (18,000 IOPS each), not on flash memory, which is slow and IMHO does not deserve the same name, 'SSD' > > 2) anyone have any oracle engines in that range? no, and the 2 who tried to go there with comparable loads were rather diasappointed by RACs thruput and went further, switching to postgres at the end. But both were NOT commercial cutomers in the traditional sense. Hope this answers your question. dic_k > > Thanks! > Mark Scranton > Xtivia Inc. -- Richard Kofler SOLID STATE EDV Dienstleistungen GmbH Vienna/Austria/Europe