Hi,

At September 27, 2004, 15:47, trac_t2000 wrote:

> I am trying to record the time it takes for certain lines of sql to
> run in a stored procedure. I added a "Process_log" table that holds
> a varchar and a timestamp. I am inserting a start and finish record
> in this new "Process_Log" table for each particular sql operation.
> Well, my problem is the time stamps are the same for every record.
> This procedure takes about 5 minutes to run, but all the time stamps
> are equal.

> I am using firebird 1.5 on Windows 2000 operating system.

What are you using to get the timestamp? CURRENT_TIMESTAMP or 'NOW'?

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)