RE: performance problem with dbd oracle

• Previous message: Ron Reidy: "RE: performance problem with dbd oracle"
• Maybe in reply to: Tim To: "performance problem with dbd oracle"
• Next in thread: Tim To: "RE: performance problem with dbd oracle"
• Reply: Tim To: "RE: performance problem with dbd oracle"
• Reply: Tim Bunce: "Re: performance problem with dbd oracle"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Date: Sat, 17 Apr 2004 14:28:02 -0600
To: <tto@redback.com>, "Tim Bunce" <Tim.Bunce@pobox.com>

Sure the network issue exists...look at your $data_source var. You are requesting a SQL*Net connection.

--
Ron Reidy
Sr DBA
Array BioPharma, Inc.
-----Original Message-----
From:	Tim To [mailto:tto@redback.com]
Sent:	Fri 4/16/2004 5:22 PM
To:	Tim Bunce
Cc:	dbi-users@perl.org
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:Tim.Bunce@pobox.com]
> Sent: Friday, April 16, 2004 3:57 PM
> To: Tim To
> Cc: Reidy, Ron; Scott T. Hildreth; jgold@cidr.jhmi.edu;
> dbi-users@perl.org
> 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.

• Previous message: Ron Reidy: "RE: performance problem with dbd oracle"
• Maybe in reply to: Tim To: "performance problem with dbd oracle"
• Next in thread: Tim To: "RE: performance problem with dbd oracle"
• Reply: Tim To: "RE: performance problem with dbd oracle"
• Reply: Tim Bunce: "Re: performance problem with dbd oracle"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]