Subject Re: [ib-support] Mass insertion speeds
Author Svein Erling Tysvær
Jason,

>Unfortunatley for me, I have to support both FB and SQLServer (Possibly
>Oracle further down the road), so I'm either going to have two methods of
>doing this, or go with something slower.

don't forget what David wrote:

>You could also run a small program to do the job using a prepared
>insert query. This removes the parsing overhead for each statement.

What is time consuming, is that every insert statement has to be prepared.
It should only take you a few minutes to write a program that creates and
prepares one insert statement with parameters, reads the input file one
record at a time, sets the parameters and executes the DSQL. If done
correctly (avoiding ParamByName), this should increase your speed to
several thousand inserts a second.

Set