Informix vs. Oracle

I don't really agree with that. For example, Oracle and Informix use completely different transaction processing. If you update a row in Informix, it remains unaccessible for other users until the end of a transaction, unless using dirty read. In Oracle, during the whole transaction the old row remains accessible, being updated at commit time. The Informix solution offers somewhat better performance (data is either in the DB or inaccessible, whereas Oracle needs to look both in the DB and in the log), the Oracle solution offers better transaction independency. Frido > -----Original Message----- > From: Devan Dewey [SMTP:devan@pobox.com] > Posted At: Tuesday, August 12, 1997 12:43 PM > Posted To: informix > Conversation: Informix vs. Oracle > Subject: Re: Informix vs. Oracle > > > The real difference between the DB engines, however, is only apparent > in > VLDB scenarios. Here, the features speak for themselves, and each has > it's own set of advantages. If you are building huge databases, then > understand your problem, and evaluate the engines with your goals in > mind. The choice should be obvious - there's no real winner. > >