RE: [sqr-users] Automatic Time Stamps to tune performance of SQR

["Watkins, David" <David.Watkins@yum.com>]

I don't' think there is an actual procedure for this; this is the only
way I know how:

let $start = datenow()

...code...

let $stop = datenow()
let #elapsed_time = datediff($stop, $start, 'minute')
print 'Run Time:  '   (15,1) bold
print #elapsed_time    (15,8) edit 99.99

HTH,
David

-----Original Message-----
From: sqr-users-bounces+david.watkins=yum.com@sqrug.org
[mailto:sqr-users-bounces+david.watkins=yum.com@sqrug.org] On Behalf Of
christophe.kirch@equant.com
Sent: Thursday, December 08, 2005 2:02 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] Automatic Time Stamps to tune performance of SQR

Hi all,
I am having trouble with the performance of an SQR.
It is very hug and very complex, containing plenty of procedures and SQL
Statements.
I would like to know the time that each SQL statements takes.
I know i can add "show datetime()" everywhere, but it is a pain to do
so.
So, isn't there a way to automatically get the time (duration) of each
SQL
statements and/or procedure.
Thank you for your help !
Rgds
Chris



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


This communication is confidential and may be legally privileged.  If you are 
not the intended recipient, (i) please do not read or disclose to others, (ii) 
please notify the sender by reply mail, and (iii) please delete this 
communication from your system.  Failure to follow this process may be 
unlawful.  Thank you for your cooperation.

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