Resend due to email list change.
----- Original Message -----
> I have recently hacked up the DBD::ODBC driver to support array
processing.
> Testing with the Oracle ODBC driver showed about a 10x improvement in
> thruput for bulk-INSERT (admittedly, the tests were very limited, only
about
> 20,000 rows on a small WinNT server). If you like, I can send you a bundle
> with those changes, though it would require a ODBC driver for your
platform,
> and is still very alpha-level software. I've also hacked up the DBI layer
to
> support a new API we've been kicking around the dev list:
> bind_param_array, bind_col_array, bind_param_status, and bind_row_status.
>
> I believe others on the lists (Mssr. Bunce, perhaps ?) were working on
> providing
> a more direct Oracle::OCI module, and a couple of other folks have
indicated
> an interest in implementing the DBD::Oracle changes.
>
> Anyhow, let me know if you would like a copy of the modified DBI and
> DBD::ODBC
> modules.
>
> Regards,
> Dean Arnold
>
> ----- Original Message -----
> From: "Ted X Wang" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, January 25, 2001 6:27 AM
> Subject: Oraperl, DBI,DBD , ARRAY PROCESSING and performance issue
>
>
> >
> >
> > Hi,Gurus:
> >
> > I'm looking for some help to spped up my perl application.
> >
> > It's a data loading program written in Oraperl, perl5.02.
> >
> > Each morning, we need to load about 50,000 records into the oracle
> database.
> >
> > The problem is that the oraperl have no way ( not to my knowledge) to do
> array processing. so the application does50,000 times sql call to the
> databasen. Each call takes about 60ms, so the whole loading program takes
> about an
> > hour, which is too long.
> >
> > Can anyboy tell me how I can use the ARRAY processing feature in ORAPERL
> or just PERL ?
> >
> > Thanks in advance.
> >
> > Ted Wang
> >
>
>
