gorepj wrote:

> Is there a faster way? Would parameter substitution help?

It definetly would. Create a statement with parameters and prepare it
before entering the loop. Inside the loop fill the parameter values and
execute statement. Don't commit after each record, instead commit for
example at every 10000th record. (Don't forget to commit after the last
record).

HTH

--
Milan Babuskov
http://fbexport.sourceforge.net