Subject Re: [firebird-support] Import data from flat files
Author Milan Babuskov
Oleg Lebedev wrote:
> I was under the impression that plain INSERTs would be too slow for the
> amount of data I need to import. That's why SQL Server has a BCP
> utility, PostgreSQL has a COPY utility. Does FireBird have any similar
> utility that would do a bulk copy for me?

External tables. You have to reformat your data from CSV to fixed length
(easy to do with some small script in C, PHP, whatever) and then attach
it as external table. After that just do:

INSERT INTO real_table (column_list, ...)
SELECT column_list,... FROM external_table;

It works really fast.


Milan Babuskov