Subject | Re: [firebird-support] Re: Handling large imports while system is in production |
---|---|
Author | W O |
Post date | 2013-02-06T13:53:11Z |
Thank you very much André. I shall try that way.
Greetings.
Walter.
On Wed, Feb 6, 2013 at 9:14 AM, André Knappstein <
Knappstein@...> wrote:
Greetings.
Walter.
On Wed, Feb 6, 2013 at 9:14 AM, André Knappstein <
Knappstein@...> wrote:
>[Non-text portions of this message have been removed]
> > Exporting the .DBF to a delimited text file and then importing using an
> > external table would be faster?
>
> Walter,
> a consultant I know has made very good experience with this.
>
> He was regularly importing DBF tables (level 5 and 7) via ODBC.
> I encouraged him to try exporting them to CSV first, then to integrate
> them as external tables. He reported a massive speed gain (2 minutes
> vs. 2 hours).
>
> It's definitely worth a try!
>
>
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>