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
> >
