Re: PLSQL execution model

From: <rtproffitt_at_my-deja.com>
Date: Fri, 27 Aug 1999 23:38:05 GMT
Message-ID: <7q77gs$auj$1@nnrp1.deja.com>

The first time a package is called it must be cached in memory, this takes time... The first time is always the slowest.
Once it is cached it stays in memory,
so all subsquent references to it are fast.

I am not sure what you mean by pre-fetching the data, but you might be able to write the package to use Reference Cursor construct, and then open the cursor at program initialization time, then not loop through the cursor until user wants to... Comments anyone?

Robert Proffitt
Beckman Coulter
Brea California

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Aug 27 1999 - 18:38:05 CDT