Subject Re: [IBO] ib_query slow copy 300.000 records.
Author Thomas Steinmaurer
> i am using TIB_Query for import data from dbf (300.000 records)
> every 10000 i do hard commit, after 100.000 records looping go very slow.
> for dbf i am using TQuery.
> slow i mean for 300.000 records i spent 3 hours.
> how to speed up?
> please help, thanks.

The following might help:

* Use a uni-directional component like TIB_Cursor instead of TIB_Query
* Set TQuery to uni-directional as well
* Use a parametrized query in TIB_Cursor and assign the parameter values
in your loop

Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
My blog: