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

["SRI Technologies" <sritech@sritech.com.au>]

There is a utility bundled with SqrPlus - called 'Performance Analysis
Tool'.
The URL is: http://www.sritech.biz/product.html

Susan.

-----Original Message-----
From: Watkins, David [mailto:David.Watkins@yum.com]
Sent: Saturday, December 10, 2005 12:46 AM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: RE: [sqr-users] Automatic Time Stamps to tune performance of
SQR



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