And you can perform direct inserts. ----------------- Ron Reidy Senior DBA Array BioPharma, Inc.
-----Original Message----- From: Scott T. Hildreth [mailto:[EMAIL PROTECTED] Sent: Friday, April 16, 2004 8:37 AM To: Reidy, Ron Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: performance problem with dbd oracle 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. > 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.
