sql_runtime in syssqltrace

Posted in 2010

Tristan Ball — Sun, 28 Nov 2010 11:55:19 — source: IIUG Forums & Mailing Lists

Hi Everyone. Can someone please tell me what unit of measure sql_runtime represents? The manual doesn't seem to say. I suspect it's seconds, but the times given don't seem to measure up to the application experience. Thanks, Tristan

↪ replying to Tristan Ball

Fernando Nunes — Sun, 28 Nov 2010 23:14:19 — source: IIUG Forums & Mailing Lists

On Sun, Nov 28, 2010 at 11:55 AM, Tristan Ball <tristanb@pronto.com.au>wrote: > Hi Everyone. > > Can someone please tell me what unit of measure sql_runtime represents? > > The manual doesn't seem to say. I suspect it's seconds, but the times given > don't seem to measure up to the application experience. > > Thanks, > > Tristan > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > AFAIK it's seconds. But be aware that there were some bugs in the values presented by sqltrace in some situations. Hopefully most (or all) of them are fixed in 11.50.FC8 (and 11.50.FC7W3). Regards. -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --000e0cd1e164f6549d0496251cf9