On May 22, 8:01 am, rem..._at_lycos.es wrote:
> Hi All,
>
> My application connects to an Oracle Server 9i via OCI.
> I have all my select statements on stored procedures, for this I use
> REF CURSOR to return the result sets.
> It is working correct but in some cases, because one trip to the
> server is needed for each row returned by the stored procedure, is
> very slow.
>
> Is there any way to enable prefetching of rows when using stored
> procedures and REF CURSORs ?
> If not, is there any other possiblity to improve perfomance when using
> ref cursor ?
>
> Thanks in advance...
You may also want to take a look at OCI_ATTR_PREFETCH_ROWS and/or
OCI_ATTR_PREFETCH_MEMORY.
Received on Tue May 22 2007 - 09:40:41 CDT
