Re: [sqr-users] actual execution time for select to process -thank you franck and victor

[Wendy Biggs <wendy.biggs@vt.edu>]

Thank you Franck and Victor ...

Both of the toys you shared have been very helpful and instructive!!

--wb


At 09:22 AM 4/6/2007, victorloghin@vgl.ca wrote:
>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



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