Subject Re: [firebird-support] Bulk upload options
Author Dimitry Sibiryakov
16.05.2018 4:48, fabianch@... [firebird-support] wrote:
> Does anyone have experience with bulk updates via isql? Would it be X times faster than using a normal application inserting the records inside a begin transaction and commit at the end?

No, because it is exactly what isql does: execute a prepared statement for each line of
data. No magic inside.

> I think this solutions will do!!!!

External tables has a definite limitations, for example you cannot put NULL into it. If
it is ok for you - fine. Otherwise the fastest way is export data into a file on one side,
compress, transfer to other side, uncompress and then parse the file and insert records
one-by-one in a single transaction.
Firebird 4 has some kind of batch interface, but I'm not sure if it can speed up bulk load.