[sqr-users] actual execution time for select to process

[victorloghin@vgl.ca]

Wendy,

I have timed the SQL in SQR programs. I have had to do it so much I actually
developed a tool to do it. It will produce a report on the performance of all
the SQR cursors in the program. The tool is available for free from my website
www.vgl.ca and is under the Tools section and it is called SQL Timor. It works
by having procedure calls before and after every SQL statement. It is such a
tedious task to insert the calls into the code I developed another tool called
the Formator to insert the procedure calls into the code.

HTH,
Victor Loghin
VGL Consulting Inc.
VictorLoghin@vgl.ca


> Message: 4
> Date: Thu, 05 Apr 2007 16:58:55 -0400
> From: Wendy Biggs <wendy.biggs@vt.edu>
> Subject: [sqr-users] actual execution time for select to process
> To: sqr-users@sqrug.org
>
> I need to determine the actual execution time of several different
> select statements.
> Has anyone else on this list done this?
> Is there an sqr variable that will get to that information?
>
> I can grab system time before & after the select statement and find
> the difference ... but that is not the same as the actual time the
> statement took to execute.
>
> Any and all help will be appreciated.
>
> <sigh>
> --wb

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users