Put an INSERT statement in a TIB_DSQL component and then store the parameter
TIB_Column references in static variables and then loop through the input
one record at a time calling ExecSQL for each one.

Be sure AutoCommit is false, call BeginBusy() and EndBusy around it and make
sure forced writes for the database are off. Also make sure indexes and
triggers are inactive too.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Bram" <bram@...>
To: <IBObjects@egroups.com>
Sent: Saturday, December 02, 2000 3:35 AM
Subject: [IBO] Import dbf data


> Which IBO component would the best/fast to import data from a dbf file
> (450.000 records) to Interbase. This table has all the zipcode's in
Holland
> and I want to use it for test/demonstration purpose to see how fast
> Interbase/IBO can be and especially to learn how to optimize querie's.
> So what would be the best/fast way to import the data. I tried an
> IBOTable(sorry...) with a loop. But that is very slow.
>
> Bram van der Voet / A&V Automatisering
> bram@... <mailto:bram@...>
> Glasbergenlaan 6
> 2235 BP VALKENBURG ZH
> tel 071 407 6956
> fax 071 407 3939
>
>
> -----Oorspronkelijk bericht-----
> Van: Andrew Barton [mailto:andrew@...]
> Verzonden: zaterdag 2 december 2000 03:31
> Aan: IBObjects@egroups.com
> Onderwerp: [IBO] IBOPipeline_Unit
>
>
> Hello all
>
> There was a thread a while ago about the new IBOPipeline_Unit for v5.5.
Has
> it been posted anywhere for download?
>
> Thanks
>
> Andy
>
>
>
>
>
>
>
>