fields24@... wrote:

>
> 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
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

Swapped TIB_Query to TIBOQuery and now it takes
less than 1 minute for the same 8000+ records:
(no changes on TIB_Connection, TIB_Transaction)
What gives?

Steve Fields