Subject Re: [IBO] ib_export and *.sch file
Author Svein Erling Tysvær
>Then from Delphi, loop through all 57,000,000 records, setting the
>Parameters, and doing the insert from the TIB_Query?

A TIB_DSQL would be better. And if you do things correctly (prepare before
the loop, avoid ParamByName and use a transaction which commits at sensible
intervals and possibly a few things more) I think that would be as good as
you get it. It is certainly much more efficient than creating the SQL for
each insert.

Set