On Sat, Apr 17, 2004 at 02:28:02PM -0600, Reidy, Ron wrote: > Sure the network issue exists...look at your $data_source var. You are requesting a > SQL*Net connection.
And even without that there would still be the interprocess communication overheads. (And your earlier point about AutoCommit was spot on. I'd missed that.) Tim. > -- > Ron Reidy > Sr DBA > Array BioPharma, Inc. > > > -----Original Message----- > From: Tim To [mailto:[EMAIL PROTECTED] > Sent: Fri 4/16/2004 5:22 PM > To: Tim Bunce > Cc: [EMAIL PROTECTED] > Subject: RE: performance problem with dbd oracle > Thanks Tim I will try that. > I am running all these tests on the same server - does the network latency > still apply? What else can I provide to get more help? Basically the app and > the environment didn't change I just ported everything from linux mysql to > oracle Solaris and we didn't see the performance problem with that combo. > Shouldn't network latency have affect DBD::mysql also? > > Tim To > > -----Original Message----- > > From: Tim Bunce [mailto:[EMAIL PROTECTED] > > Sent: Friday, April 16, 2004 3:57 PM > > To: Tim To > > Cc: Reidy, Ron; Scott T. Hildreth; [EMAIL PROTECTED]; > > [EMAIL PROTECTED] > > Subject: Re: performance problem with dbd oracle > > > > > > On Fri, Apr 16, 2004 at 11:07:04AM -0700, Tim To wrote: > > > The performance problem is actually worse with the real app which I have > > > ported from Linux mysql to Solaris oracle. The worst of the > > statements is > > > executing a commit after three or so insert/update statement so > > I've created > > > a couple of insert only test scripts for comparison(That's when the five > > > times slowdown was noticed). They both do the same thing but one's an > > > anonymous block in pl/sql and the other's using perl > > DBI/DBD::oracle hence > > > through OCI. > > > > > Using sqlloader is not feasible here since I'm just trying to > > > isolate the performance problem with the real app and not > > really trying to > > > do bulk load alone. At this point I'm more interested to see if > > anyone have > > > used dbd/dbi with oracle 9i and do they have any performance > > problem similar > > > to what I'm seeing. And if available what's the solution. > > > > The 'problem' is simply the extra time it takes for each execute > > request to get from the client to the server and for the result > > packet to get back: Latency. > > > > The pl/sql version just ships the whole code to the server and > > executes it with one request. > > > > You could just take the "anonymous block in pl/sql" and put it in > > a $dbh->do(...) statement (without the leading "set"s and > > training "/exit") > > and you'll find the speed is the same :) > > > > Without knowing more about what the real application is doing (not this > > very artificial test) it's hard to help more. > > > > Tim. > > > > 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. > >
