RE: Oracle vs. Informix debate

It may have been a little faster at a specific type of transaction, but I
can't believe that when you add backup and recovery, stability tco etc that
Oracle would lose to Informix. I would hammer them on the specifics of the
"test" and point out any weaknesses.

The other thing for mgmt to consider is finding qualified people to work on
your systems. How many people know Informix? I am sure that it is a fine product, but I have never met anyone who uses it. What is the learning curve? How hard/easy is it to tune?

As far as the company goes, I wouldn't put my production system on it. The
company has been unstable for years and is viewed that way in the industry.

Sorry I don't have any more specific URL's....perhaps others on the list can
help...

my 2 cents..

Frank Pettinato
Oracle DBA
Intel Corp.

-----Original Message-----

alan.aschenbrenner_at_ihs.com
Sent: Friday, August 04, 2000 12:29 PM
To: Multiple recipients of list ORACLE-L

Hi everyone,

    Recently I changed jobs and was hired on as an Oracle DBA in Denver, CO.
About a month before I started, a big debate started about which DBMS to run
(since their Oracle contract was almost up for renewal). Some managers were
questioning why some of the databases were so slow (and want to migrate some
databases away from Ingres also), so they decided to hold a test.

    They decided to benchmark Oracle, Infromix, and DB2 against each other.
The results turned out that Informix was roughly 10 times faster than Oracle, and DB2 was only somewhat faster than Oracle. Here's the catch though, both IBM and Informix sent guys out to tune their databases. The
Oracle database was only tuned in-house. (Since this test took place before
I got here, I had no hand in this). Anyway, it looks like management may be
leaning towards Informix, especially after 4 salesman from Informix came
here and gave a great marketing speech that any manager would love!

    Any suggestions on papers to read on comparisons, opinions, etc. Is Informix really that much faster? What about 3rd party tools? It seems to
me that most tools are written with Oracle in mind, not Informix. And how
about company stability? It makes me a little nervous to convert to Informix after watching the stock price of Informix plunge over the past several months down to nearly $4 a share! Plus, they just hired an ORACLE
DBA, not an Informix DBA!!!!! (Which makes me wonder if I'll be employed in
a few months...) Any other valid points in this argument / debate?

Thanks,

Alan

Alan Aschenbrenner
Oracle DBA
IHS Group
alan.aschenbrenner_at_ihs.com
--

Author:

--openmail-part-09a818f2-00000001

Content-Type: application/ms-tnef; name="WINMAIL.DAT"
Content-Disposition: attachment; filename="WINMAIL.DAT"
Content-Transfer-Encoding: base64

eJ8+ItdcAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5N aWNyb3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEEgAEAHwAAAFJFOiBPcmFjbGUg dnMuIEluZm9ybWl4IGRlYmF0ZQBvCgEFgAMADgAAANAHCAAHABAAEwAEAAEADgEBAIAAAKAA AAAEAKAAQgBOAEpvaG4gSi4gS2FuYWdhcmFqIC9GSUMzMjEsT1BFTk1BSUwvbz1CUlVORUkg U0hFTEwgUEVUUk9MRVVNIFNFUklBAE9QRU5NQUlMOkpvaG4gSi4gS2FuYWdhcmFqIC9GSUMz MjEsT1BFTk1BSUwvbz1CUlVORUlcIFNIRUxMXCBQRVRST0xFVU1cIFNFUklBAAAAAAAAAAAA JyoBIIADAA4AAADQBwgABwAQAAwAGgABAB0BAQmAAQAhAAAAOENCNzM5NjBGMTZCRDQxMTkz ODIwMDYwOTc5OTExQjMA5AYBBJAGAAQCAAABAAAAEgAAAAMAADACAAAACwAPDgAAAAACAf8P AQAAAEcAAAAAAAAAgSsfpL6jEBmdbgDdAQ9UAgAAAQBvcmFjbGUtbEBmYXRjaXR5LmNvbQBT TVRQAG9yYWNsZS1sQGZhdGNpdHkuY29tAAAeAAIwAQAAAAUAAABTTVRQAAAAAB4AAzABAAAA FQAAAG9yYWNsZS1sQGZhdGNpdHkuY29tAAAAAAMAFQwBAAAAAgH5DwEAAABHAAAAAAAAAIEr H6S+oxAZnW4A3QEPVAIAAAEQb3JhY2xlLWxAZmF0Y2l0eS5jb20AU01UUABvcmFjbGUtbEBm YXRjaXR5LmNvbQAAAwD+DwYAAAAeAAEwAQAAABcAAAAnb3JhY2xlLWxAZmF0Y2l0eS5jb20n AAACAQswAQAAABoAAABTTVRQOk9SQUNMRS1MQEZBVENJVFkuQ09NAAAAAwAAOQAAAAALAEA6 AAAAAAMAcToAAAAAHgD2XwEAAAAVAAAAb3JhY2xlLWxAZmF0Y2l0eS5jb20AAAAAAgH3XwEA AABHAAAAAAAAAIErH6S+oxAZnW4A3QEPVAIAAAEAb3JhY2xlLWxAZmF0Y2l0eS5jb20AU01U UABvcmFjbGUtbEBmYXRjaXR5LmNvbQAAAwD9XwEAAAADAP9fAAAAAAIB9g8BAAAABAAAAAAA AALBbwEDkAYAHAQAACIAAAALAAIAAQAAAAsAIwAAAAAAAwAmAAAAAAALACkAAAAAAAMANgAA AAAAQAA5AFC19yVIAMABHgBCAAEAAABCAAAASm9obiBKLiBLYW5hZ2FyYWogL0ZJQzMyMSxP UEVOTUFJTC9vPUJSVU5FSSBTSEVMTCBQRVRST0xFVU0gU0VSSUEAAABAAEgA0My5JkgAwAEe AHAAAQAAAB8AAABSRTogT3JhY2xlIHZzLiBJbmZvcm1peCBkZWJhdGUAAAIBcQABAAAAFgAA AAHAAEgl8GA5t41r8RHUk4IAYJeZEbMAAB4AGgwBAAAAQgAAAEpvaG4gSi4gS2FuYWdhcmFq IC9GSUMzMjEsT1BFTk1BSUwvbz1CUlVORUkgU0hFTEwgUEVUUk9MRVVNIFNFUklBAAAAAgEd DAEAAABOAAAAT1BFTk1BSUw6Sk9ITiBKLiBLQU5BR0FSQUogL0ZJQzMyMSxPUEVOTUFJTC9P PUJSVU5FSVwgU0hFTExcIFBFVFJPTEVVTVwgU0VSSUEAAAAeAB4MAQAAAAkAAABPUEVOTUFJ TAAAAAAeAB8MAQAAAEUAAABKb2huIEouIEthbmFnYXJhaiAvRklDMzIxLE9QRU5NQUlML289 QlJVTkVJXCBTSEVMTFwgUEVUUk9MRVVNXCBTRVJJQQAAAAADAIAQ/////0AABzBwGOU4RwDA AUAACDBwGOU4RwDAAQMA3j+vbwAACwAAgAggBgAAAAAAwAAAAAAAAEYAAAAAA4UAAAAAAAAD AAKACCAGAAAAAADAAAAAAAAARgAAAAAQhQAAAAAAAAMACIAIIAYAAAAAAMAAAAAAAABGAAAA AAGFAAAAAAAAAwAWgAggBgAAAAAAwAAAAAAAAEYAAAAAEYUAAAAAAAADACeACCAGAAAAAADA AAAAAAAARgAAAABShQAA4xUAAB4AKIAIIAYAAAAAAMAAAAAAAABGAAAAAFSFAAABAAAABAAA ADguNQALACmACCAGAAAAAADAAAAAAAAARgAAAAAGhQAAAAAAAAsALYAIIAYAAAAAAMAAAAAA AABGAAAAAA6FAAAAAAAAAwAvgAggBgAAAAAAwAAAAAAAAEYAAAAAGIUAAAAAAAAeAD2ACCAG AAAAAADAAAAAAAAARgAAAAA2hQAAAQAAAAEAAAAAAAAAHgA+gAggBgAAAAAAwAAAAAAAAEYA AAAAN4UAAAEAAAABAAAAAAAAAB4AP4AIIAYAAAAAAMAAAAAAAABGAAAAADiFAAABAAAAAQAA AAAAAAALAEqACyAGAAAAAADAAAAAAAAARgAAAAAAiAAAAAAAAAsATIALIAYAAAAAAMAAAAAA Received on Sat Aug 05 2000 - 08:41:39 CDT