Subject Re: [firebird-support] Looking for library to create external tables without FB
Author Milan Babuskov
maximshiryaev wrote:
> I'm looking for a tool to bulk load from DBFs. Probably via external
> table. Simple way of reading DBF and executing INSERT's takes 30 min
> for 1mln records. Copy of 1 mln inside FB between two tables takes 5
> min for 1 mln records.

And how long does it take to read in DBF and just dump it into .txt file?

My guess is: 25 min :)

Anyway, it all depends on your hardware, but 30 min seems way too much
(I just used FBExport to insert a 1.6mil records from .fbx file to
Firebird and it took about 4 minutes).

Are you using prepared statements and parameters?
Do you disable triggers and/or indexes while importing?

Is it possible that it's really DBF access layer that reads it too slow?

Milan Babuskov