Subject Re: [firebird-support] tracking progress of a SP
Author Bill Kranec
I'm sorry, I just realized that I read your message too fast, and answered
a question that you weren't asking. Unfortunately I don't know the answer
to your real question.

Sorry again,

Bill

On Sun, 20 Mar 2005, Rick Roen wrote:

>
>
> I was trying to track the internal progress of a SP that was running
> quite slow.
>
> I created an external table, then wrote to the table at various
> points from within the SP and updated using CURRENT_TIME and a note
> field. Of course, as I later learned from the documentation the
> CURRENT_TIME was set at the beginning of the SP and never
> incremented.
>
> I finally figured out what was causing the slow processing, but I
> would like to know for the future if something like this is
> possible. I tried to Google, but only got information as to why it
> doesn't work.
>
> Is there any way to get a real CURRENT_TIME from within a SP?
>
> Thanks,
>
> Rick
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>