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