Subject RE: [firebird-support] Looking for library to create external tables without FB
Author Leyne, Sean

> 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.

Are you using a local or remote connection to the database?

Are you using a prepared INSERT statement with parameters?

30 min for 1 million records seems slow... I would have expected
performance on the order of at least 1,200 rows per second.