On Wed, 12 Dec 2001, Joe Koenig wrote:
> inserts faster in groups of 1,000 or 5,000? I know that letting each
> insert be in its own transaction creates a lot of overhead, but I didn't
> know if putting 5,000 inserts into a transaction created overhead for
> that transaction. Hopefully my question makes sense. Thanks,
Have you tried putting them all in one transaction?
That may be the easiest approach.
I would think that a group of 1000 has a higher overhead than 5000.