On Mon, Apr 29, 2002 at 01:18:53PM -0700, Calin Medianu wrote: > Hello, > > I did the following. Wrote a perl script that retreves > data via a straight select from the database. Then I > wrote a stored procedure returning a ref cursor open > on the same select statement and retrieved the data as > well. Using the REF CURSOR/ sotred procedure was about > 3 time slower, that is 40 seconds instead of around > 10. > > Is this normal? Is this a problem with oracle or with > DBD::Oracle?
DBD::Oracle. It probably isn't setting up a row cache for the ref cursor. Get a level 3 trace and look for the "dbd_describe'd" line for the ref cursor. Tim.
