Re: PLSQL execution model

From: <>
Date: Fri, 27 Aug 1999 23:38:05 GMT
Message-ID: <7q77gs$auj$>

[Quoted] 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.

[Quoted] 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
Share what you know. Learn what you don't. Received on Sat Aug 28 1999 - 01:38:05 CEST

Original text of this message