Subject Re: [firebird-support] URGENT Performance problem
Author Elmar Haneke
> I have a program done with Delphi. This inserts row by row and this
> takes to long.
>
> What's the fastest way to make a Batchmove from Oracle to Firebird?


In theory using external files sould be most performant.

In practice you should first make shure that

* Inserts are done by using prepared statements

* Transaction is not committed to often. Especially an "auto commit"
does break performance since it has to create an new transaction on each
insert.

* You might consider to deactivate index updates while loading your
data. Recreating them afterwards might take less time.

Elmar