Subject Slow append of records
Author fields24@bellsouth.net
I am populating a table with records from a
paradox table. There are approx 8100 records.
After the first 500 or so records the appends
slow down to about one second per append of
the IB records. In the same program I have another
dataset that appends/posts several hundred records
in only a few seconds. Any Ideas?

Local IB6 but on a server, IBO 3Di, Paradox 5.
Using tiConsistancy, AutoCommit, Server AutoCommit,
Forced writes, No synchs in the TIB_Query,
No indexes in the IB Table (26 fields). The conversion
is a simple
IBTable.Append
FieldByName()... := FieldByName()...
IBTable.Post
PdxTable.Next

I have tried TIB_Cursor: no change, Indexes in the
table make no difference.
(The LAN is a 10/100 with a PIII 450 to a PIII 850
server)

Thanks
Steve Fields