Subject | Re: [firebird-support] Proper way for copy data from big table |
---|---|
Author | Mark Rotteveel |
Post date | 2015-06-19T14:49:20Z |
On Fri, 19 Jun 2015 16:43:37 +0200, "Mark Rotteveel mark@...
[firebird-support]" <firebird-support@yahoogroups.com> wrote:
Mark
[firebird-support]" <firebird-support@yahoogroups.com> wrote:
> The proper way to do this is to execute a single query, and interleaveThat
> fetching of rows from the source with inserting rows into the target.
> should work without consuming all memory as long as the component youuse
> 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