This one made my day.
Not a technical problem thread but an anecdote/discussion. Art Kagel reports an unnamed large Informix site (50+ servers) that migrated to Oracle 11 and found one ported application ran three to four times slower than on Informix 7.31, speculating that staying current through IDS 11.50 would have widened the gap further. Replies joke about the vendor, guess at the customer's identity, ask whether they might switch back, and note IBM was pushing DB2 to Informix customers years earlier. No technical issue is diagnosed and no resolution is recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Just one more anecdote to share around. A major, nameless, Informix site with over 50 servers online, who was talked into converting all of their servers into Oracle in the past year, is having major performance problems with several of the handful of already ported applications and their databases. One such application, still in conformance and performance testing before moving to production, is reported to be three to four times faster running under Informix 7.31 than under Oracle 11! Imagine if they had taken advice given them 4+ years ago and upgraded to IDS 9.40 and kept up through IDS 11.50 which cumulatively would have given them an additional 20-35% performance improvement over 7.31 (I think that works out to another 100% additional performance over Oracle)! Now, I do not doubt that the Oracle instances could use some tuning, the users' DBAs are not Oracle novices they have had Oracle servers online alongside IDS for over 6 years and IB there are Oracle consultants onsite helping with porting and configuration, but I for one don't think anyone will be able to coax 300% additional throughput out of those servers. -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.
"Art Kagel" <art.kagel@gmail.com> wrote in message news:mailman.374.1227463105.874.informix-list@iiug.org... >> A major, nameless, Informix site with over 50 servers online, who was >> talked into converting all of their servers into Oracle in the past year, >> is having major performance problems with several of the handful of >> already ported applications and their databases. One such application, >> still in conformance and performance testing before moving to production, >> is reported to be three to four times faster running under Informix 7.31 >> than under Oracle 11! Imagine if they had taken advice given them 4+ >> years ago and upgraded to IDS 9.40 and kept up through IDS 11.50 which >> cumulatively would have given them an additional 20-35% performance >> improvement over 7.31 (I think that works out to another 100% additional >> performance over Oracle)! Now, I do not doubt that the Oracle instances >> could use some tuning, the users' DBAs are not Oracle novices they have >> had Oracle servers online alongside IDS for over 6 years and IB there are >> Oracle consultants onsite helping with porting and configuration, but I >> for one don't think anyone will be able to coax 300% additional >> throughput out of those servers. Interesting stuff. Ha Ha Ha is what I say! Must they remain nameless though, Art? If so, why?
Art Kagel wrote: > Just one more anecdote to share around. > > A major, nameless, Informix site with over 50 servers online, who was > talked into converting all of their servers into Oracle in the past > year, is having major performance problems with several of the handful > of already ported applications and their databases. One such > application, still in conformance and performance testing before moving > to production, is reported to be three to four times faster running > under Informix 7.31 than under Oracle 11! Imagine if they had taken > advice given them 4+ years ago and upgraded to IDS 9.40 and kept up > through IDS 11.50 which cumulatively would have given them an additional > 20-35% performance improvement over 7.31 (I think that works out to > another 100% additional performance over Oracle)! Now, I do not doubt > that the Oracle instances could use some tuning, the users' DBAs are not > Oracle novices they have had Oracle servers online alongside IDS for > over 6 years and IB there are Oracle consultants onsite helping with > porting and configuration, but I for one don't think anyone will be able > to coax 300% additional throughput out of those servers. > Any chance of getting them to convert back to Informix? Too much of an investment in Oracle? JWC
Art Kagel wrote: > Just one more anecdote to share around. > > A major, nameless, Informix site with over 50 servers online, who was > talked into converting all of their servers into Oracle in the past > year, is having major performance problems with several of the handful > of already ported applications and their databases. One such > application, still in conformance and performance testing before moving > to production, is reported to be three to four times faster running > under Informix 7.31 than under Oracle 11! Imagine if they had taken > advice given them 4+ years ago and upgraded to IDS 9.40 and kept up > through IDS 11.50 which cumulatively would have given them an additional > 20-35% performance improvement over 7.31 (I think that works out to > another 100% additional performance over Oracle)! Now, I do not doubt > that the Oracle instances could use some tuning, the users' DBAs are not > Oracle novices they have had Oracle servers online alongside IDS for > over 6 years and IB there are Oracle consultants onsite helping with > porting and configuration, but I for one don't think anyone will be able > to coax 300% additional throughput out of those servers. > Great news Art. More proof that marketing triumphs over everything. -ID- > -- > Art S. Kagel > Oninit (www.oninit.com <http://www.oninit.com>) > IIUG Board of Directors (art@iiug.org <mailto:art@iiug.org>) > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on my employer, Oninit, the IIUG, nor any other > organization with which I am associated either explicitly or implicitly. > Neither do those opinions reflect those of other individuals affiliated > with any entity with which I am affiliated nor those of the entities > themselves. >
On 23 Nov, 19:52, "Neil Truby" <neil.tr...@ardenta.com> wrote: > "Art Kagel" <art.ka...@gmail.com> wrote in message > > news:mailman.374.1227463105.874.informix-list@iiug.org... > > > > > > >> A major, nameless, Informix site with over 50 servers online, who was > >> talked into converting all of their servers into Oracle in the past year, > >> is having major performance problems with several of the handful of > >> already ported applications and their databases. One such application, > >> still in conformance and performance testing before moving to production, > >> is reported to be three to four times faster running under Informix 7.31 > >> than under Oracle 11! Imagine if they had taken advice given them 4+ > >> years ago and upgraded to IDS 9.40 and kept up through IDS 11.50 which > >> cumulatively would have given them an additional 20-35% performance > >> improvement over 7.31 (I think that works out to another 100% additional > >> performance over Oracle)! Now, I do not doubt that the Oracle instances > >> could use some tuning, the users' DBAs are not Oracle novices they have > >> had Oracle servers online alongside IDS for over 6 years and IB there are > >> Oracle consultants onsite helping with porting and configuration, but I > >> for one don't think anyone will be able to coax 300% additional > >> throughput out of those servers. > > Interesting stuff. Ha Ha Ha is what I say! > Must they remain nameless though, Art? If so, why?- Hide quoted text - > > - Show quoted text - That would be Bloomberg then?
> From: david@smooth1.co.uk > Subject: Re: This one made my day. > Date: Mon, 24 Nov 2008 14:33:23 -0800 > To: informix-list@iiug.org > > On 23 Nov, 19:52, "Neil Truby" <neil.tr...@ardenta.com> wrote: > > "Art Kagel" <art.ka...@gmail.com> wrote in message > > > > news:mailman.374.1227463105.874.informix-list@iiug.org... > > > > > > > > > > > > >> A major, nameless, Informix site with over 50 servers online, who was > > >> talked into converting all of their servers into Oracle in the past year, > > >> is having major performance problems with several of the handful of > > >> already ported applications and their databases. One such application, > > >> still in conformance and performance testing before moving to production, > > >> is reported to be three to four times faster running under Informix 7.31 > > >> than under Oracle 11! Imagine if they had taken advice given them 4+ > > >> years ago and upgraded to IDS 9.40 and kept up through IDS 11.50 which > > >> cumulatively would have given them an additional 20-35% performance > > >> improvement over 7.31 (I think that works out to another 100% additional > > >> performance over Oracle)! Now, I do not doubt that the Oracle instances > > >> could use some tuning, the users' DBAs are not Oracle novices they have > > >> had Oracle servers online alongside IDS for over 6 years and IB there are > > >> Oracle consultants onsite helping with porting and configuration, but I > > >> for one don't think anyone will be able to coax 300% additional > > >> throughput out of those servers. > > > > Interesting stuff. Ha Ha Ha is what I say! > > Must they remain nameless though, Art? If so, why?- Hide quoted text - > > > > - Show quoted text - > > That would be Bloomberg then? LOL... Going by Art's comment 4+ years ago, IBM was trying to convince their Informix customers that they should go to DB2. So if you were an Informix customer, which database would you switch to? ;-) Of course part of the problem is that if you were to switch databases, any adverse effect from the decision will take years to come out and bite you in the arse. So one has to ask... How many people who were involved in the decision 4+ years ago to make the switch are still in the same capacity today at said unknown company? We can't cry over spilled milk. We need to clean it up and move on. _________________________________________________________________ Get more done, have more fun, and stay more connected with Windows Mobile®. http://clk.atdmt.com/MRT/go/119642556/direct/01/
Related threads
- the longer you surf, the MORE $$$ you earn !!
- Store procedure
- emulation for Vt100
- extent size questions again ...