Re: DBD::Oracle dbd_st_execute slow speed

No, but another great suggestion! Let me see if that turns up anything....




Rudy Lippan <[email protected]> 
12/13/2010 01:04 PM

To
<[email protected]>
cc
John Scoles <[email protected]>, "Martin J. Evans" 
<[email protected]>, <[email protected]>
Subject
Re: DBD::Oracle dbd_st_execute slow speed







On 12/13/2010 12:04 PM, [email protected] wrote:
> Martin, John, list

>         Any ideas list? I like the direction the threading idea was 
going 
> but  unless someone can re-explain it to me I think the fact that only 
the 
> execute() is slow and not the commi() it doesn't make sense. sqlplus's 
> execute would be on my thread and should take just as long as 
DBD::Oracle.
> 
>         Thanks for your help but the DBA and I are fresh out of ideas 
and 
> performance is still terrible :(
> 
>         Server 1:
>                 AIX 6.1
>                 Perl (v5.12.2)
>                 $DBI::VERSION = "1.615"
>                 $DBD::Oracle::VERSION = '1.26'
>         Server 2:
>                 AIX 5.3
>                 Perl v5.8.8
>                 $DBI::VERSION = "1.51"; 
>                 $DBD::Oracle::VERSION = '1.17';
> 
> 


Have you tried strace or wireshark/tcpdump?

-r




Please consider the environment before printing this email.