| Subject | RE: [firebird-support] Looking for library to create external tables without FB |
|---|---|
| Author | Leyne, Sean |
| Post date | 2008-04-16T16:44:26Z |
Maxim,
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.
Sean
> I'm looking for a tool to bulk load from DBFs. Probably viaAre you using a local or remote connection to the database?
> external table. Simple way of reading DBF and executing
> INSERT's takes 30 min for 1mln records.
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.
Sean