Subject | TimeStamp Problem in procedures |
---|---|
Author | trac_t2000 |
Post date | 2004-09-27T18:47:28Z |
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.
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.