Subject | Re: [ib-support] Mass insertion speeds |
---|---|
Author | Svein Erling Tysvær |
Post date | 2002-06-07T06:51:53Z |
Jason,
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
>Unfortunatley for me, I have to support both FB and SQLServer (Possiblydon't forget what David wrote:
>Oracle further down the road), so I'm either going to have two methods of
>doing this, or go with something slower.
>You could also run a small program to do the job using a preparedWhat is time consuming, is that every insert statement has to be prepared.
>insert query. This removes the parsing overhead for each statement.
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