Subject Re: [firebird-support] Importing large amount of data.
Author Martijn Tonies
Hello Darin,

> I am importing a large number of records into a firebird table
> programatically from a text file with ansi C. ie 1 million records. It
> seems stupid to generate a sql statement for each record, that would
> be really slow. What support does Firebird have for such an import?
> Can the SQL interface help me or is there another way to do it?

There are plenty of tools that can do this for you ... Ours is one of
them ( Database Workbench - )

The fastest way to import fixed length text data, is by using an external
table. This allows you to do an:

insert into normal_table select * from external_table

You can check the InterBase 6 documentation on how to use this.

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
My thoughts:
Database development questions? Check the forum!