Subject RE: [firebird-support] Re: Handling large imports while system is in production
Author Leyne, Sean
Walter,

> Karol, currently now I am importing a .DBF table which has more or less
> 3.600.000 records and it is taking hours.

Back in 1994 I was able to insert 1000 rows/secs into a IB database from an DBF file.

So, you need to review your import routine approach/coding.


> Exporting the .DBF to a delimited text file and then importing using an
> external table would be faster?

Orders of magnitude.


Sean