--- In [email protected], Ann Harrison wrote: > > 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] >
Ann, Im having a hard time trying to find out some concise manual or tutorial on external files/tables and how to import with them (Im finding out a lot of separate, segmented articles tho). Can you provide some internet resources I could look up?
