Re: Informix vs. Oracle

---- you wrote: > Keith > As with most people that dislike change but it is not all that > bad as long as you understand the fundamental principles behind a > relational database. I have used both databases for several years and > personally I prefer Oracle to Informix. I am sure that the biggest > reason that your management wants to switch to Oracle is that 99% ( > Everyone but Documentum) of DMS vendors do not support Informix but do > support Oracle. As far as speed Oracle wins hands down. Go see for > yourself at www.tpc.org <http://www.tpc.org>; this is a third party > organization that all the big database players belong to in the pure > speed section Informix does not even show up in the top ten. Dude, to be in the top ten you have to perform TPC benchmarks. I think there was about 14 months when Informix didn't do any. If you think people choose a database based on TPC figures then our initial opinion of you must be correct. > Do not be > fooled Oracle takes a lot of time and analysis and tweaking to get into > a fine tuned state. A lot of tweaking?! TPC consider it cheating. So much so that they have had to change their benchmarks! > Informix on the other hand out of the box runs > fairly well just out of the box. If you don't really care about > performance and don't want to spend the time learning the ins and outs > of your engine stay with Informix. Dude, I don't believe you have ever used Informix. Certainly not a multi-threaded variety engine anyway. > The only other thing would be the > backups as far as disaster recovery there both about the same. For I > screwed up and need to restore a table back to a certain point in time > Oracle wins Informix has some major flaws in there thinking the > developers admit it and are working to correct the problem but see no > solution for the next three years. This did not go over well at the > Informix Users Conference. So Informix looks after it's data integrity better than others. That's tough on a poor dumb programmer who updates the wrong table, isn't it? > Personally if I could get my current > management to make the change from Informix to Oracle I would be > ecstatic. You would be in shit more like. But keep it up Dude. Oracle needs supporters for their database products. As an application vendor, it's nice for them to have a side-line. AB ---------------------------------------------------------------- Get your free email from AltaVista at http://altavista.iname.com