[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: [sqr-users] Automatic Time Stamps to tune performance ofSQR
- Subject: Re: [sqr-users] Automatic Time Stamps to tune performance ofSQR
- From: "George Jansen" <gjansen@aflcio.org>
- Date: Fri, 09 Dec 2005 06:27:41 -0500
- Delivery-date: Fri, 09 Dec 2005 10:36:48 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Can you trace on the database side?
>>> christophe.kirch@equant.com 12/08/05 2:01 PM >>>
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
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users