Re: Stored procedure overhead

Paul Mailman wrote: > some recent experimentation appears to show that there can be a > surprisingly large overhead involved in stored procedure execution. > the entire stored procedure > happened essentially instantaneously, yet it took nearly 6 seconds to return Uh... Never mind. I've just had it pointed out to me that the value of "CURRENT", which I used to log times, is not guaranteed to change between multiple references inside the same procedure. Thus the "instantaneous" execution followed by the "slow" return was illusion, an artifact of the use of CURRENT. It looks like I'm back to a more laborious process of analyzing the individual queries without the assistance of any automatic timestamping coded into the procedures.