On Wed, Feb 6, 2013 at 8:14 AM, André Knappstein <
Knappstein@...> wrote:

>
> > Exporting the .DBF to a delimited text file and then importing using an
> > external table would be faster?
>
> 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).
>
> Loading data from a file requires a round trip between the database and

client for each row, even if you're using prepared statements. If you're
not using prepared statements, you should. Importing data from an external
table requires one round trip between client and database .All the
processing happens inside the database. If your situation allows you to
make the conversion to an external table and make the table available to
the database, take advantage of it to improve load times. Excellent
suggestion.

Best,

Ann


[Non-text portions of this message have been removed]