Re: Isolation levels in Informix vs Oracle
Posted in 2004
Topics: Transactions, Locking & Isolation
Mark Townsend said: > Obnoxio The Chav wrote: > >> Mark was trying to drag the discussion into a feature battle >> that was irrelevant to the issue at hand. > > Au contraire. The discussion was around a justification for dirty read. > The OP opined that dirty reads were useful for determining status of a > very long running transaction that spanned multiple DMLS. I questioned > if this was really a likely scenario, knowing a little about the It all depends on how the code is written. I don't like the approach much, but sometimes you gots to do what you gots to do. > propblems such long transactions can cause (in both Oracle and > Informix), and, as an aside to this questioning, wondered aloud if So it wasn't really relevant, was it? >:o) > Informix had save points. I genuinely wanted to know. The feature Yeah, yeah, yeah. > battles with Informix are long, long over. Yeah, yeah, yeah. Pull the other one. It has (festive) bells on it. :o) -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco I went to the airport to check in and they asked what I did because I looked like a terrorist. I said I was a comedian. They said, "Say something funny then." I told them I had just graduated from flying school. -- Ahmed Ahmed sending to informix-list
Obnoxio The Chav wrote: > Pull the other one. It has (festive) bells on it. :o) Ew. TMI and can't you get an ointment for that ?