Subject | Re: IB Clustering (random thoughts and questions) |
---|---|
Author | ac.hi@switzerland.org |
Post date | 2001-08-09T04:43:28Z |
Hi David
...
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
...
> 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 aWhen I was doing once a similar thing with IBO I kept my CPU busy
> clients data using that option.
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