Re: Informix beats Oracle

Mark Jamison wrote: > 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> As I wrote answering to Serge, I believe this is not optimistic locking. And we can configure it on instance level, session level, and depending on the previous isolation level... An Informix DBA dream :) Regards. -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...

Fernando, thanks too for your response. I read your website article and it was good too. I have been under the impression that this one feature is what Oracle sells to clients, that they have the best non-blocking database engine available. Perhaps this is a bit simplistic, but it is notable that applications and developers now have another choice of what engine to use if indeed this is similar to the Oracle implementation, and was not available in other products. -t- Fernando Nunes wrote: > Mark Jamison wrote: >> 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>> > > As I wrote answering to Serge, I believe this is not optimistic locking. > And we can configure it on instance level, session level, and depending > on the previous isolation level... An Informix DBA dream :) > > Regards. >