Subject | Re: [firebird-support] Re: Bulk inserts in Interbase |
---|---|
Author | Ann W. Harrison |
Post date | 2005-01-25T18:48:20Z |
spgilmore wrote:
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
>>What do you mean by a bulk insert?Milan is correct - the closest Firebird equivalent is an external file.
>
> 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.
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