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
http://www.flamerobin.org