Subject Re: [IBO] Re: Pumping data uses a lot of memory
Author Lester Caine
williamvdw2005 wrote:

> Thanks for the response.
>
> No blobs.
>
> I am using TIB_Query for source and destination at the moment. I assume
> that I should use TIB_Cursor for the source and TIB_DSQL for the
> destination?

That would be more efficient then you would not be buffering quite so
much stuff, and I normally add a FIRST 100 SKIP xxx so I can manage
where I have got to and stop and start. All works nicely then ;)

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services
Treasurer - Firebird Foundation Inc.