Subject: Re: Oracle Stored Procs take longer than embedded SQL

From: Tim Bunce <[email-masked]>
Date: Tue, 16 May 2000 22:23:50 +0100

On Tue, May 16, 2000 at 06:48:22PM +0100, [email-masked] wrote:
> I have a problem with the fetching of data from an Oracle Ref Cursor taking longer than the same query in Embeded SQL.
> 
> $ get_sp.pl
> Fetched in 0.00774896144866943 seconds
> Completed in 0.106827020645142 seconds
> 
> $ get_sql.pl
> Fetched in 0.00138604640960693 seconds
> Completed in 0.380790948867798 seconds
> 
> In this example (Using the SCOTT/TIGER tables), while the Stored Procedure completed first, the actual fetch of the data took considerably longer. In a real situation (e.g. bigger tables ), this is easily the longest part of the task and causes the overall execution time to increase hugely.
> 
> Any Help would be appreciated 
> thanks

Possibly related to the lack of a row cache on that statement handle.
You, or some kind volunteer, could probably hack that in without too
much work.

Tim.

------------------------------------------------------------------------------
DBI HOME PAGE AND ARCHIVES: http://www.symbolstone.org/technology/perl/DBI/
To unsubscribe from this list, please visit: http://www.isc.org/dbi-lists.html
If you are without web access, or if you are having trouble with the web page, 
please send mail to [email-masked] with the subject line of:
'unsubscribe'.
------------------------------------------------------------------------------