Subject RE: [firebird-support] tracking progress of a SP
Author Bogdan
Use 'now' instead of CURRENT_TIME

Bogdan

>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
>os>sible. I tried to Google, but only got information as to why it
>Does>n't work.
>
>Is there any way to get a real CURRENT_TIME from within a SP?

>Rick






Yahoo! Groups Links









--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.7.4 - Release Date: 18.3.2005