RE: IDS Next Version - features wanted - again widely on topic

-----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Data Goob Sent: 14 June 2005 01:11 AM To: informix-list@iiug.org Subject: Re: IDS Next Version - features wanted - again widely on topic Dirk Moolman wrote: > One thing I love about Informix, is how simple yet powerful it is. We > started moving to Oracle, and I don't want to go into detail - but I > appreciate Informix more now. > > It is easy to install, easy to setup, and very stable - like Unix. > > Maybe I am old school, I don't know. > > >And you didn't tell me one thing about Informix that is different >or compelling enough to use it instead of something else. Oracle >is not too difficult to install, but I do agree it is more difficult >to use and manage than Informix. But think about life outside Informix >for a moment: > >DB2 is easy to install, easy to setup, and very stable - like UNIX. >MySQL is easy to install, easy to setup, and very stable. - like UNIX. >Sybase is easy to install, easy to setup, and very stable. - like UNIX. >Postgres is easy to install, easy to setup, and very stable. - like UNIX. >Ms-SQL-Server is easy to install, easy to setup, and very stable. - like >UNIX. > >So, after a day of waiting for someone to say something compelling about >Informix vs something else, NONE OF YOU have done so. Informix is >interesting, >and has a lot of great features, but I've yet to hear why it should be >chosen over any other product in the mainstream market. > >Here's one for you: DB2 is more tunable than Informix, and allows you to >tune memory management better than Informix, so why would I use Informix >instead of DB2? DB2 has lots of tools to migrate from SQL-Server, >and make Microsoft Developers happy, does Informix have this? Gimme >something. With regards to Oracle (from the little exposure I had, and watching my fellow DBA, who focuses on Oracle) - Oracle has very good tuning capabilities, but you can tie yourself into a knot trying to be too fancy, and using too much of its tuning capabilities - Oracle then becomes difficult to manage / maintain. I see how much time is spent here in keeping Oracle stable and running. If you don't plan your Oracle installation properly, it becomes a nightmare. The Oracle fans will probably now disagree with me, but I am just stating my experience with Informix and Oracle. As mentioned in this thread, Informix needs a lot less TLC than Oracle does (in our setup anyway). Dirk sending to informix-list