Yes, committing in chunks significantly sped up our apps too. However, I
guess for the original post inserts don't need to be addressed... I forgot
that SQLLoader was going to be used. Is that a Perl tool or something
that comes with Oracle... I've never heard of it until now (or just never
paid attention when it was mentioned before).
--Curt
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.
>
> ----
> Steve Sapovits
> Global Sports Interactive
> Work Email: [EMAIL PROTECTED]
> Home Email: [EMAIL PROTECTED]
> Work Phone: 610-491-7087
> Cell: 610-574-7706
> Pager: 877-239-4003
>
