Re: Oracle vs Informix comparison

Stephen A Tahmosh wrote: } } 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. Didn't say it was better (re-read my post). Said there are performance implications for interrupting a processing thread to go off and do data replication stuff. Informix data replication has the ability to selectively define replicates for 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 -- Carol Davies cdavies@csc.com