like we’ll always have that tradeoff.
Yep. You could also stick some cache or parallel hints in there as well
that way.
Can you do me a favor and trap one of these queries in your dev log?
I want to make sure that what I told you is true. I’ve been doing
some research (meet my assistant, Mr. Google), and I’m finding some
discussions from the end of 2004 that imply that the functionality
you want could be in place in the Oracle adapter. I’ll try to track
it down from my end as well.
The OCI8 driver definitely supports bind parameters, so I’m guessing the
adapter would use them as well, though I’m not positive.
I actually don’t know how useful bind parameters are going to be in the
context of web development, since users are (presumably) going to be
bouncing around to different pages doing different queries, and thus the
previous queries would be bumped out of the cache. I guess it depends
on your schema and SGA setup.
Regards,
Dan