Subject | Re: [firebird-support] Re: Handling large imports while system is in production |
---|---|
Author | W O |
Post date | 2013-02-06T18:49Z |
Thank you for the info Sean.
Greetings.
Walter.
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]