Subject Re: Looking for library to create external tables without FB
Author maximshiryaev

DBF is read by TDBF ( Simple scroll is very
fast - less than 2 minutes.
No triggers, no indicies, no forced writes, one transaction for each
1000 records, prepared query, tried ZEOS instead of DBX, tried
embedded. Embedded+ZEOS is the winner but is still not fast...

Will try FBExport. It's file format is very well documented and
supports nulls as I see. 4 minutes is a very good time indeed though
I have 12mln to pump...


--- In, Milan Babuskov <milanb@...>
> maximshiryaev wrote:
> > I'm looking for a tool to bulk load from DBFs. Probably via
> > table. Simple way of reading DBF and executing INSERT's takes 30
> > 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
> (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
> --
> Milan Babuskov