Re: Oraperl / DBD / Perl5 Performance for Oracle query?

In article <68r3rr$6hv$1_at_rdsunx.crd.ge.com>, kornfein@.crd.ge.com (Mark Kornfein) writes:
>
> I've recently come on board a web project that uses the Oraperl emulation
> interface for DBD. The performance is horrible, a query that returns in 4-5
> seconds from sqlplus takes 50 seconds, This is just to do the "fetch"
> without calling any cgi scripts.

Is that *just* the fetch, or are you looking at Perl invocation, parsing, connection to Oracle, the query opening, and then the fetch? Usually, the time is in the connection to Oracle, and the README for DBD::Oracle gives some hints and tips on that. For example, are you using SQL*Net, and if so, do you actually need to?

Also, are you running them on a level playing-field? Do repeated invocations of the queries return a consistent discrepancy between the two methods, or are you losing a lot while Oracle loads its cache?

-- 
<Steve_Kilbane_at_cegelecproj.co.uk> - All opinions are mine alone.
Kilbane's law of integration: standardise on protocols and file
formats, and the applications take care of themselves.