WOW!!!!

THAT'S INCREDIBLE!!!!!!!

Importing row by row 3.600.000 records takes about 14 hours. Importing
1.160.000 records using an external table takes seconds, less than a minute.

Thanks very much to all for the advice.

Greetings.

Walter.

On Wed, Feb 6, 2013 at 2:49 PM, W O <sistemas2000profesional@...>wrote:

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