Re: Oracle vs Informix comparison

peggy wrote: } } HI everybody: } } NOTE: this is being posted on behalf of someone else. } ---------------------------------------------- } } We are in the middle of planning the implementation of a new } enterprise system for our company with approximately: 1500 users + } including various remote locations on the WAN such as it is. } } Most of our usage will be transaction based namely select, insert and } updates. No Warehousing yet at this stage. } } How do Oracle and Informix stack up in terms of: } - number of concurrent users } - stability of their RDBMS servers } - stability of their connectivity components } - standard SQL } - Replication and syncronization capabilities to remote sites Recently had a demo of Informix 7.2.2, which contains the new Informix data replication feature. The Informix techie pointed out (somewhat enthusiastically, if not smuggly) that the Informix data replication is driven off of the Informix logical logs (i.e. is triggered when the data reaches the transaction logging process), and thus in no way negatively affects the performance of the application thread. In contrast, he stated the Oracle data replication is based on triggers, stored procedures on the database, and thus interrupts the application process in mid-stream. Something to consider if you have real performance considerations to account for. } - Level of difficulty in maintainig and supporting the Oracle server vs. } Informix server } - Learning curve associated with the above products for DBA and sql } users } - the kind of support to expect from their support staff or do we have } to depend } on the net to answer most of our questions } - How often do we run into bugs in their software } } Please excuse my ignorance and if possible please spare the flames. } Also please send all responses directly to my e-mail: iac@frc.com } } Thanks a lot. All positive feedback is appreciated and if requested will } summarize } and post it to the requested newsgroups. -- Carol Davies cdavies@csc.com