Subject Re: [firebird-support] Re: Bulk inserts in Interbase
Author Ann W. Harrison
spgilmore wrote:

>>What do you mean by a bulk insert?
>
> My background is in MSSQL, where a bulk insert is an actual SQL
> statement that you issue. It specifies the location of a "flat file"
> (delimited text file) with any number of rows in it. It will then
> glue this file into the tables in the RDBMS all at once.

Milan is correct - the closest Firebird equivalent is an external file.
However, when you move data from the external file to the database, it
still moves 1 record at a time. Faster than most alternatives, but it's
still not "gluing" two files together.

Regards,


Ann