Subject | Re: [IBO] Faster Datapump from FoxPro/Paradox to Firebird |
---|---|
Author | Svein Erling Tysvær |
Post date | 2002-02-28T13:10:14Z |
>for a table of only 630 record and 15 columns an Athlon 700Mhz in cpLocalYes,definitely! It should take at most some seconds to connect to your
>connection work about 2 minutes!!
>Can i accelerate the process?
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