Re: Stored procedure overhead

Paul Mailman wrote: > > That is, within the resolution of the clock, the entire stored procedure > happened essentially instantaneously, yet it took nearly 6 seconds to return > from myproc() and execute the "end" log. > Informix makes time stand still within SPL execution; it always refers to the starting time. I've used system("date >> mylogfile") sprinkled around to get various times. The system call is expensive though, and takes about 0.5 seconds on my system, but it can be used to find really long winded statements. -Peter