Subject | Re: [firebird-support] URGENT Performance problem |
---|---|
Author | Elmar Haneke |
Post date | 2007-04-08T12:08:55Z |
> I have a program done with Delphi. This inserts row by row and thisIn theory using external files sould be most performant.
> takes to long.
>
> What's the fastest way to make a Batchmove from Oracle to Firebird?
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