Subject Re: [ib-support] Re: insert optimization (long)
Author Erik S. LaBianca
Yes, I did try it. It knocked off about 10 seconds off the 5 minute run.
See my earlier email for details.

--erik


Svein Erling wrote:
> 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. :)
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>

--
Erik S. LaBianca <erik@...>
Developer / System Administrator, Interlink, Inc.
Voice: (269) 473-3103 Fax: (269) 473-1190
http://www.totalcirculation.com