On Fri, 8 Jun 2001, Steve Sapovits wrote:
..
> We've also found that committing in blocks speeds up heavy
> inserts with Perl/DBI/Oracle. How big depends on the job.
> Most people do all or nothing: AutoCommit or no commit and
> a rollback or commit at the end. Something in between usually
> is better for most inserts.
Definitely autocommit is extremely slow, while one big commit at the end
simply won't cut it -- rollback segment can't hold all the pending
transactions. My personal experience is, a commit every 50 or so
transactions is OK. I haven't really tried to twiddle that value though.
--
Orlando Andico <[EMAIL PROTECTED]>
Mosaic Communications, Inc.
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GE d(-) s: a-25 C++++ UBLSI++++$ P+++ L+++>++++ E- W++ N(+)
o K? w O-- M- !V PS(++) PE- Y PGP-- t(+)@ 5(+) X++@ R(+) tv@
b++ DI++ G e++@ h--(*) r% y+
------END GEEK CODE BLOCK------
