RE: performance problem with dbd oracle

From: Tim To (tto_at_redback.com)
Date: 04/17/04 

To: "Tim Bunce" <Tim.Bunce@pobox.com>
Date: Fri, 16 Apr 2004 16:22:54 -0700

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.

Relevant Pages

  • Re: Slow connections & Select database
    ... If you want to check for network latency, you can do a series of pingfrom the client to the server and if you want to get fancy, do a traceroute as well. ... Did Rosie try a different database? ... > we are having problems with slow connections on our informix database. ...
    (comp.databases.informix)
  • Re: Mailbox replication
    ... Next question then is how heavily utilised are the connections and what is ... the network latency on these connections as latency is the killer for user ... jON ... where their home server is located? ...
    (microsoft.public.exchange.admin)
  • Re: Some mmap observations compared to Linux 2.6/OpenBSD
    ... > the assertion that there is an mmapperformance problem. ... how many regions did SpecWeb99 map? ... and the Flash server used to keep a cache of mmap'd regions. ... Our new server basically gave up on using mapped files entirely due ...
    (freebsd-hackers)
  • Printer Driver for Windows 2003 Clustered Server
    ... Printer drivers installed on NT4.0 client from the Windwos 2003 Clustered ... server has a serious performance problem with displaying the Properties ... Samething happens to opening the Printing Preferences page. ... server and NT4.0 client environment. ...
    (microsoft.public.development.device.drivers)
  • MSDE does not react any more
    ... local MSDE database. ... performance problem. ... when I stop and restart the server service by service manager ...
    (microsoft.public.sqlserver.server)