[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] Automatic Time Stamps to tune performance of SQR
- Subject: [sqr-users] Automatic Time Stamps to tune performance of SQR
- From: christophe.kirch@equant.com
- Date: Thu, 8 Dec 2005 20:01:49 +0100
- Delivery-date: Thu, 08 Dec 2005 23:24:27 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
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