Re: Isolation levels in Informix vs Oracle

Posted in 2004

DA Morgan — Wed, 15 Dec 2004 15:07:05 -0800 — source: Usenet: comp.databases.informix

rkusenet wrote: > to add more, because of Oracle's versioning feature, I feel that its > FOR UPDATE technique is less efficient. For e.g if there is a > work flow table where competing sessions try to grab the first > available row in the queue. May be that's why Oracle recommends > using AQ tables for such a task. It would certainly be my recommendation in Oracle to use Advanced Queuing or Streams. But from my experience FOR UPDATE works in 99+% of all similar situations. You lock it if you're first ... you don't if otherwise. -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace 'x' with 'u' to respond)