On Fri, 2004-04-16 at 09:24, Reidy, Ron wrote:
> Tim,
>
> What performance problems are you having exactly? Did you run a 10046 trace? Are
> you passing the {ora_check_sql => 0} in your prepare() call?
>
> Also, I would suggest you look into SQL*Loader. Nothing you ever write in Perl will
> give you the insert speed you will get with this utility.
...when array processing is available, it will be pretty close in
speed.
>
> -----------------
> Ron Reidy
> Senior DBA
> Array BioPharma, Inc.
>
>
> -----Original Message-----
> From: Tim To [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 15, 2004 11:53 AM
> To: [EMAIL PROTECTED]
> Subject: performance problem with dbd oracle
>
>
> Hi,
> How can I improve performance when using oracle dbd? We have an urgent
> performance problem where inserting data into an Oracle 9i database using
> DBI/DBD oracle is at least five times slower than stright sql using sqlplus.
> Any suggestion is appreciated.
>
> DBD::oracle 1.15
> DBI 1.4
> PERL 5.8.0
> running on solaris 9
> Oracle 9.2.0.1
>
> Thanks,
> Tim To
>
>
> This electronic message transmission is a PRIVATE communication which contains
> information which may be confidential or privileged. The information is intended
> to be for the use of the individual or entity named above. If you are not the
> intended recipient, please be aware that any disclosure, copying, distribution
> or use of the contents of this information is prohibited. Please notify the
> sender of the delivery error by replying to this message, or notify us by
> telephone (877-633-2436, ext. 0), and then delete it from your system.
>
