Subject Re: [firebird-support] Proper way for copy data from big table
Author Mark Rotteveel
On Fri, 19 Jun 2015 16:43:37 +0200, "Mark Rotteveel mark@...
[firebird-support]" <firebird-support@yahoogroups.com> wrote:
> The proper way to do this is to execute a single query, and interleave
> fetching of rows from the source with inserting rows into the target.
That
> should work without consuming all memory as long as the component you
use
> for querying doesn't fetch all rows at once or doesn't discard them.

Hmm, that should have read "and discards them [when no longer necessary]".

Mark