Re: PLSQL execution model
From: <rtproffitt_at_my-deja.com>
Date: Fri, 27 Aug 1999 23:38:05 GMT
Message-ID: <7q77gs$auj$1_at_nnrp1.deja.com>
Date: Fri, 27 Aug 1999 23:38:05 GMT
Message-ID: <7q77gs$auj$1_at_nnrp1.deja.com>
[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 Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Sat Aug 28 1999 - 01:38:05 CEST