Subject Re: insert optimization (long)
Author Svein Erling
One thing you could try Erik, is to commit every 10000 records rather
than every 1000 records. I don't know if this is enough to equal
MySQL, but I would expect it to speed up the insertion process.

Set

--- In ib-support@yahoogroups.com, "Erik S. LaBianca" <erik@t...>
wrote:
> if ($count % 1000 == 999) {
> $dbh->commit();
> }