Re: SQR Performance evaluation

[David Dawes Stanley <stanledd@SNYONEVA.CC.ONEONTA.EDU>]

Yea,
        I use a procedure called EVENT_TRACE with this SQL code
BEGIN-SQL
  ALTER SESSION SET SQL_TRACE TRUE
END-SQL

        This procedure can be set to run in debug mode or the call to this
procedure can be commented out until needed. I'm running on an Alpha under
Open VMS, so I end up with a [somename].TRC file. I execute the following
from the command line:
$TKPROF ________.TRC TEMP.LIS EXPLAIN=[USERNAME/PASSWORD]
you can then use your editor to look at the data.

> -----Original Message-----
> From: Discussion of SQR, SQRIBE Technologies's database reporting
> language [mailto:SQR-USERS@list.iex.net]On Behalf Of GINO SANTERRE
> Sent: Thursday, October 08, 1998 9:33 AM
> To: Multiple recipients of list SQR-USERS
> Subject: SQR Performance evaluation
>
>
> Can we put a trace or something like that in an Sqr to know in detail the
> time of each query and where is the time consuming?
>
> Gino Santerre
> Le Groupe QuebecTel
>