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

  • ODBC / mssql very slow
    ... In my current project I have a performance problem. ... That same queryX takes 2 seconds to complete when executed in SQL Server Management Studio. ... I have the impression my slow performance is caused by the fact that ODBC fetches each record one by one. ... "There are two ways of constructing a software design: One way is to make it so simple that there are obviously no deficiencies, and the other way is to make it so complicated that there are no obvious deficiencies. ...
    (comp.databases.ms-sqlserver)
  • ODBC (mssql) fetches results really slow
    ... In my current project I have a performance problem. ... That same queryX takes 2 seconds to complete when executed in SQL Server Management Studio. ... I have the impression my slow performance is caused by the fact that ODBC fetches each record one by one. ... Is there some way to make ODBC fetch all records faster? ...
    (microsoft.public.sqlserver.odbc)
  • 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)
  • hp dl-380 and freebsd 6.4,7.1 problem
    ... I have two hp dl-380 server with 6.4 and 7.1 freebsd, but all of them have a poor performance. ... Reference machine (AMD 2500 Athlon, pata disk, 6.4 bsd with generic kernel): ... # time tar xvzf php-5.1.4.tar.gz ... The performance problem is come forward again while executiing a php script, its 10x slower then running same script on the reference machine. ...
    (freebsd-hackers)