| Subject | Re: Handling large imports while system is in production |
|---|---|
| Author | karolbieniaszewski |
| Post date | 2013-02-06T12:53:28Z |
--- In firebird-support@yahoogroups.com, W O wrote:
i do not talking about csv file only about EXTERNAL TABLE
and yes import by external table is much faster
then putting insert statement one by one
regards,
Karol Bieniaszewski
>Hi,
> Karol, currently now I am importing a .DBF table which has more or less
> 3.600.000 records and it is taking hours.
>
> Exporting the .DBF to a delimited text file and then importing using an
> external table would be faster?
>
> Thanks in advance.
>
> Walter.
>
i do not talking about csv file only about EXTERNAL TABLE
and yes import by external table is much faster
then putting insert statement one by one
regards,
Karol Bieniaszewski