Re: How to profile SQR code?

[Bob Buford <bbuford@CCCI.ORG>]

Fred,

I identify progress points and write to a text file (DEBUG.LOG) at each point.  I can include various info in text to show what my variable values are.  I don't always use time stamping, but certainly that is an easy option to include.  I actually put the logging feature as part of an SQC so I could call it from a number of SQRs without copy/pasting all over.

OTOH, one of my colleagues writest to a table (SQR_JOB_STATUS) when he reaches any progress point - time and other text information.

Hope this helps,
Bob

>>> Schiff Fred <FSCHIFF@NLFS.COM> 10/13 9:54 AM >>>
How do I go about profiling a piece of SQR code?
I want to see whats taking so long.  I have a program which takes 2 hours to
run.
It produces seperate reports for around ~800 people, and the time has gone
up
as the number of reports it has to produce has gone up.  I'm pretty
confident
that the queries are all ok, but I'd like to know for sure.

The real problem is that I have to run the sqr report multiple times because
of
formating and where clause constraints, so its actually taking 6 hours every
night.

Fred Schiff (fschiff@nlfs.com)
212/354-8800 x250
Nathan & Lewis Securities, Inc.