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?


Thanks in advance
William

--- In IBObjects@yahoogroups.com, "Jason Wharton" <jwharton@i...> wrote:
>
> > I am pumping about a million records from one database to another
> > using IB_Datapump. This process is using a lot of memory causing my
> > server to run out of virtual memory.
> >
> > Can anyone help.
>
> Is it using any BLOB columns?
>
> Are you using TIB_Cursor components, TIB_DSQL components and/or
TIB_Query
> components?
>
> Jason Wharton
>