On Apr 16, 2008, at 9:19 PM, Don Baccus wrote:
On Apr 16, 2008, at 8:19 PM, Jade Rubick wrote:
Can someone explain why we need prepared statements? I thought by
using bind variables, we avoid the SQL parse time (at least with
Oracle, that's my understanding) if you're using the same SQL but
with different values in your bind variables.
Yes, Oracle will cache the parse for you automatically if you tell
it to.
A little googling reveals that it's possible to do in-db plan caching
and, as of 11g, in-db result set caching also, in Oracle.
(the OpenACS db api provides result set caching ...)
----
Don Baccus
http://donb.photo.net
http://birdnotes.net
http://openacs.org
--
AOLserver - http://www.aolserver.com/
To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]>
with the
body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject:
field of your email blank.
