> 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
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/