Did you try my suggestion to commit every 10000 records rather than
every 1000? As you say, 2000 rec/sec is pretty good, but if run on
decent hardware it should be possible to make it run faster than
that. After all, your table was pretty simple with only a few small
fields wasn't it?

Set

--- In ib-support@yahoogroups.com, "Erik S. LaBianca" <erik@t...>
wrote:

>That being said, 2000 records/sec is still pretty good. :)