Subject | Re: insert optimization (long) |
---|---|
Author | Svein Erling |
Post date | 2003-05-27T21:41:25Z |
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:
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();
> }