Subject Re: [firebird-support] Re: Handling large imports while system is in production
Author W O
Thank you for the info Sean.

Greetings.

Walter.



On Wed, Feb 6, 2013 at 1:25 PM, Leyne, Sean <Sean@...>wrote:

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


[Non-text portions of this message have been removed]