| Author |
How to capture number of rows loaded and the time
|
|
|
| How can I capture the number of rows loaded and the time it
took
in variables?
| |
|
| which method are you using; 'load table' or the 'insert
location' syntax to load your tables?
> How can I capture the number of rows loaded and the time
> it took
> in variables?
| |
|
| I am using load table[color=darkred]
> which method are you using; 'load table' or the 'insert
> location' syntax to load your tables?
| |
|
| We use load table too and parse .iqmsg file by script into
table for statistics. It is reason to my request for freeze
.iqmsg format with ISO datetimes and always introduce owner
of object.
[color=darkred]
> I am using load table
| |
|
| > How can I capture the number of rows loaded and the time
> it took
> in variables?
We use load table too and parse .iqmsg file by script into
table for statistics. It is reason to my request for freeze
.iqmsg format with ISO datetimes and always introduce owner
of object.
| |
| Marc Zampetti 2005-12-02, 9:24 am |
| cd wrote:
> How can I capture the number of rows loaded and the time it
> took
> in variables?
The number of rows is availabe in the var @@rowcount after the load
table command. For timing, just dump the start time into a var before
the load, and the end time after the load into a seperate table, and you
can compute the load time.
Marc
|
|
|
|