Martijn Tonies wrote:

> 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 - www.upscene.com )
>
> 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
> http://www.upscene.com
> My thoughts:
> http://blog.upscene.com/martijn/
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>
>
>

And if your text file it's not in fixed length format, and you need to
use your app to import data, use prepared statements. It will save the
engine a lot of work, and then will be a lot fast.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br