Re: Informix beats Oracle

Hi t, I'm not Serge, but the answer to that is yes. As of 11.10, you can have pessimistic-locking, or optimistic locking. Entirely configurable at the instance level. The onconfig parameter is USELASTCOMMITTED ----- Original Message ---- From: Tool <tool@thetool.com> To: informix-list@iiug.org Sent: Monday, June 18, 2007 1:26:57 PM Subject: Re: Informix beats Oracle Serge, Got me to want to actually ask you a question. :-) It's my understanding that all other DBMS products are pessimistic-locking, ORACLE is optimistic-locking, Oracle being only one in this category of mainstream DBMS products to have optimistic locking. Does this mean Informix has both pessimistic _and_ optimistic locking? Thanks, -t- Serge Rielau wrote: > DA Morgan wrote: >> No CTO has ever purchased an RDBMS based on efficient use of CPU. >> Instead of following the bouncing ball how about asking IBM to make the >> same changes to Informix they just made to Viper 2 so it will support >> major business applications? > Hmmm... nice stitching. IDS has traditionally watched Oracle closer than > DB2 has, so many of the features you allude to are already present (like > DECODE, UNIQUE, Oracle sequence syntax...). also IDS has "readers don't > block writers, ..." which eliminated the perhaps single biggest > stumbling block for porting Oracle apps. > > Cheers > Serge _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list