No, but another great suggestion! Let me see if that turns up anything....
Rudy Lippan <rlip...@remotelinux.com> 12/13/2010 01:04 PM To <ericbamba...@discover.com> cc John Scoles <sco...@pythian.com>, "Martin J. Evans" <martin.ev...@easysoft.com>, <dbi-users@perl.org> Subject Re: DBD::Oracle dbd_st_execute slow speed On 12/13/2010 12:04 PM, ericbamba...@discover.com 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.
