Subject Re: [IBO] Faster Datapump from FoxPro/Paradox to Firebird
Author Svein Erling Tysvær
>for a table of only 630 record and 15 columns an Athlon 700Mhz in cpLocal
>connection work about 2 minutes!!

>Can i accelerate the process?

Yes,definitely! It should take at most some seconds to connect to your
connection and commit your transaction, but then your inserts should be
done in no more than a couple of seconds (I've transferred about 4000
records per second from one IB database to another, and I think other have
achieved twice that speed).

>But why the insert/post on Firebird are so slow?

Probably because you don't understand how to do things. Two minutes to
transfer 630 records sounds as if you are at least committing for every
record.

As Daniel and Harald has told you, use a TIB_DSQL with a parameterized
insert statement rather than a TIB_Cursor. Use an explicit transaction
without AutoCommit, prepare your TIB_DSQL and then in a loop assign the
parameters using Params[] (ParamByName will slow things down), and call
ExecSQL (or Execute). When you're finished inserting everything, call commit.

I normally add BeginBusy/EndBusy outside my loops, but I doubt that is
necessary if you don't display anything.

This should help,
Set