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

["Steve Cavill" <steve.cavill@infoclarity.com.au>]

Datenow() sqr function will retur the time.
Why do you say "I can grab system time before & after the select statement and 
find the difference"
That's the elapsed time of the select.  If you want the query execution CPU 
time you would need to look at the database logs.
Steve.

-----Original Message-----
From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org
[mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org] On Behalf 
Of Wendy Biggs
Sent: Friday, 6 April 2007 6:59 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] actual execution time for select to process

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