Subject | RE: [firebird-support] tracking progress of a SP |
---|---|
Author | Bogdan |
Post date | 2005-03-21T07:22:01Z |
Use 'now' instead of CURRENT_TIME
Bogdan
--
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
Bogdan
>I was trying to track the internal progress of a SP that was runningYahoo! Groups Links
>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
--
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