Subject Re: IB Clustering (random thoughts and questions)
Author ac.hi@switzerland.org
Hi David

...
> To import data, I can: a) use an external application using IBO to
> perform a series of parameterized inserts, b) use a script file of
> insert statements containing a whole bunch of insert statements
> created from the clients data, or c) use the 'External Files'
> approach (which is somewhat of an arcane process).

..
> Option 'A' is INCREDIBLY slow. It might take a week to import a
> clients data using that option.

When I was doing once a similar thing with IBO I kept my CPU busy
because I used all the time "FieldByName"-method do access the fields.
Replacing it by direct references of the fields speeded up the import
a lot, specially for tables with a lot of fields.


Daniel Achermann