Subject Re: Lightning fast load huge data feature at Firebird
Author Joao Kho
Hi Helen,

Sorry for late reply,

IBDataPump may be a good tool, but what i really need is, programmable
/flexible import that I can scan any header data and doing import on
the fly.

I search the feature of CREATE TABLE [EXTERNAL], but still could not
figure out how to use it. Could anyone can give me a examples?

Best Regards,
Joao Kho

--- In, Helen Borrie <helebor@...> wrote:
> At 07:02 PM 19/05/2007, you wrote:
> >Hi all,
> >
> >I'm a new bie here.
> >There is any function on firebird to load huge data with lightning
> >fast as MySQL (LOAD DATA INFILE) or SQLite (.import) ?
> Those utilities don't come with Firebird. However, there are
> third-party utilities available, including free ones such as
> IBDatapump by Clever Components (
> )
> >Because there are many huge data today in the real world especially on
> >GIS or other realtime application, they could insert few hundred
> >thousand or million on a seconds. And many exchange data using the
> >simple csv or tab-delimeted format.
> If you can acquire the external data in fixed field length format,
> you can read it directly as an external table.
> >If not available now, that will be support it someday?
> Probably. The code already exists to import csv. There is a reason
> why it hasn't been activated, although I don't recall the reason. It
> might be a question of Microsoft patents...
> ./hb