Re: Isolation levels in Informix vs Oracle

DA Morgan said: > > Actually it can guage completion on statements it is just seeing for the > very first time. It evaluates CPU utilization, i/o, and other factors to > create the initial estimate, based on system load, and then refines the > estimate over the time the process runs. From experience I find that it > is generally in the ballpark at the beginning and by 10% of the way > through is accurate to within a very small percentage. What is nice is Unless of course someone throws a honking big high-priority job in at 11%... > that as other jobs utilize resources it refines its estimate taking them > into account. Yeah, that would never happen in the way I coded my progress monitoring. Gee, let me switch to Oracle right away, it does things that I have a library for. -- 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: > DA Morgan said: > >>Actually it can guage completion on statements it is just seeing for the >>very first time. It evaluates CPU utilization, i/o, and other factors to >>create the initial estimate, based on system load, and then refines the >>estimate over the time the process runs. From experience I find that it >>is generally in the ballpark at the beginning and by 10% of the way >>through is accurate to within a very small percentage. What is nice is > > > Unless of course someone throws a honking big high-priority job in at 11%... Perhaps I wasn't clear. They can throw it in at 90% and the calculation is adjusted. What I was trying to indicate was that by 10% or so it is highly refined. Sorry for the lack of clarity. >>that as other jobs utilize resources it refines its estimate taking them >>into account. > > Yeah, that would never happen in the way I coded my progress monitoring. > Gee, let me switch to Oracle right away, it does things that I have a > library for. Yeah. Why would anyone want, built-in and included in a product, something they could charge their employer thousands of dollars to reinvent. I keep forgetting I bill by the hour. -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace 'x' with 'u' to respond)