"does CF cache the query or is the DB that caches it" My understanding is: neither of these systems cache the query. What happens is SQL creates an execution plan when it gets a SQL statement to process. Where cfqueryparam is used, this plan is saved, (I would guess this is an instruction passed by Java to have this happen) and on subsequent processing takes this step out because it has already created it. Hence the performance gain.
Thats my understanding - I think its close, however I know I am probably missing the nuances of this process. Duncan On 3/5/07, Andrew Scott <[EMAIL PROTECTED]> wrote: > > Charlie, > > Well then I will try to not to pick on you then:-) > > What I said was I see no reason to use cfqueryparam for security originally, > because I was unaware of the performance boost by it caching the query. But > having said that the RDBMS has to support bind variables first for it to > cache and work this way to begin with. > > When I mention SP, I was saying that I would prefer to use them and not > referring to ou :-) > > Now all that aside after I think about it more, I can see a huge benefit in > using stored procedures not for security but for the caching, but I would > like to know does CF cache the query or is the DB that caches it? Just in > case someone knows and can post before I get a chance to do some research on > it. > > > > Andrew Scott > Senior Coldfusion Developer > Aegeon Pty. Ltd. > www.aegeon.com.au > Phone:+613 8676 4223 > Mobile: 0404 998 273 > > > -----Original Message----- > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf > Of Charlie Arehart > Sent: Saturday, 3 March 2007 3:44 AM > To: cfaussie@googlegroups.com > Subject: [cfaussie] Re: CFQUERYPARAM was RE: [cfaussie] Re: @#$!! queryparam > > > Andrew, I didn't say anything about SPs, nor did I (or would I) argue > against them. In fact, there's nothing in my reply nor in your note I was > replying to that discussed them. > > In my note to you (which I'll assume you are replying to here, since you > didn't include it but I did offer two last night), I was just talking about > clarifying which caching was being discussed, since you mentioned query > caching while Duncan had referred to plan caching. And then we were > suggesting not to just view CFQueryParam as a security tool. > > That said, can you reframe your question below? If it was just referring, > like Duncan, to my point about Select *, I hope I've answered that in my > last note. > > And let's not make this "pick on Charlie" day. Goodness, I'm just here to > try to help. I never mean to get into a pissing match with anyone. I'm > certainly not trying to smack anyone down or show my stick is bigger. I just > like to share info and point out opportunities to correct or clarify. > Email's a notoriously bad communication vehicle when it comes to conveying > emotion. I just want to be clear that I have don't mean ever in my notes to > be picking a fight or trying to one up anyone. I hope that helps put my > responses in perspective. > > /Charlie > http://www.carehart.org/blog/ > > -----Original Message----- > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf > Of Andrew Scott > Sent: Thursday, March 01, 2007 10:30 PM > To: cfaussie@googlegroups.com > Subject: [cfaussie] CFQUERYPARAM was RE: [cfaussie] Re: @#$!! queryparam > > > Charlie, > > Can you do me a favour, and explain the typically valuable for performance > issue. I don't understand that, because to me better performance would mean > to have it as an SP to begin with. > > > Andrew Scott > Senior Coldfusion Developer > Aegeon Pty. Ltd. > www.aegeon.com.au > Phone:+613 8676 4223 > Mobile: 0404 998 273 > > > > > > > > > > > > -- Duncan I Loxton [EMAIL PROTECTED] --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
