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

["Bob Stone" <bstone@fastenal.com>]

SHOW statements are great for this.  Do a 'get-time' procedure of some
sort (make your own, select sysdate from dual) and show the date a lot
of places in your program.

If you're really ambitious, select the sysdate in a format that would
allow you to do some math on the timings.  Maybe a #hour, #min, #sec
variable - carry the 60, that sort of thing.

SELECT to_char(sysdate, 'HH24') &hour,
to_char(sysdate, 'MI') &min,
to_char(sysdate, 'SS') &sec

FROM DUAL

something like

if #new_hour < #old_hour
  #display_hours = (#new_hour + 24) - (#old_hour)
else
  #display_hours = #new_hour - #old_hour
end-if

if #new_mins < #old_mins
  #display_mins = (#new_mins + 60) - (#old_mins)
else
  #display_mins = #new_mins - #old_mins
end-if

show 'timings - ' #display_hours ':' #display_mins

-----Original Message-----
From: sqr-users-bounces+bstone=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org] On Behalf Of
Wendy Biggs
Sent: Thursday, April 05, 2007 3:59 PM
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