One problem we had with SQL*Loader direct loads is that if we had duplicate
key values on unique indexes, the table was left in an unstable condition.
We avoided that problem by not creating the indexes until after the load was
complete. That also helped performance when we moved data using the
SQL*Plus COPY command.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
----- Original Message -----
From: "Steve Sapovits" <[EMAIL PROTECTED]>
To: "Curt Russell Crandall" <[EMAIL PROTECTED]>
Cc: "Pettit, Chris L" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, June 08, 2001 10:16
Subject: RE: Data Extract
>
> It comes with Oracle and it is extremely fast. Now I
> know why. For large loads and ones that work directly
> off supported formats we use it. We sometimes use Perl
> to prepare files to feed it.
>
> ----
> 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
>
> > -----Original Message-----
> > From: Curt Russell Crandall [SMTP:[EMAIL PROTECTED]]
> > Sent: Friday, June 08, 2001 1:12 PM
> > To: Steve Sapovits
> > Cc: Pettit, Chris L; '[EMAIL PROTECTED]'
> > Subject: RE: Data Extract
> >
> > 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
> > >
>
