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

["the dragon" <ceprn@hotmail.com>]

You really wouldn't want to do that if the sqr processes a bunch of records. 
  But you could, and then use it with a debug[x] where [x] is a letter of 
the alphabet, and then the coode would only execute when you want it to, 
rather than having to put code in and take code out.  I'd try the -s option 
at run time and see if that helps any.

peace,
clark 'the dragon' willis



PSA: Salary <> Slavery. If you earn a salary, your employer is renting your 
services for 40 hours a week, not purchasing your soul. Your time is the 
only real finite asset that you have, and once used it can never be 
recovered, so don't waste it by giving it away.

I work to live; I don't live to work.

"Time is the coin of your life. It is the only coin you have, and only you 
can determine how it will be spent. Be careful lest you let other people 
spend it for you."

Carl Sandburg
(1878 - 1967)

NOTICE: The information contained in this message is protected under United 
States and international copyright laws and is intended for the personal and 
confidential use of the addressee. If you are not the addressee or an agent 
of the addressee, you are hereby notified that you have received this 
message in error and that any review, dissemination, distribution, taking of 
any action in reliance upon or copying of this message without the express 
written permission of the sender or his agent is strictly




----Original Message Follows----

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

_________________________________________________________________
Don’t just search. Find. Check out the new MSN Search! 
http://search.msn.click-url.com/go/onm00200636ave/direct/01/


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