Re: Oracle vs Informix comparison

Why is replication off of the logs automatically better than that provided via stored procedures and triggers? All data (almost) is logged - not all data is replicated (usually). Triggers/Stored Procedures can be defined only on objects which need replication. Steve :cdavies@csc.com (Carol Davies) wrote: ;>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 ; Steve Tahmosh State Street Bank