Yes, you're right, Duncan. But to Andrew, a very important point need to be made again: you're confusing query caching (caching the results of a SQL SELECT statement) with query plan caching (what Duncan is describing).
CFQUERYPARAM affects query plan caching. That caching is entirely in the database. As Scott later wrote, the CACHEDWITHIN and CACHEDAFTER attributes of CFQUERY affect whether a given query's results are cached. That caching is done in CF, and to answer the later questions, yes the "Cached Queries" feature in the CFAdmin controls how many cached results are allowed to be kept in memory. If you set it to 0, then I would expect you're saying "allocate no memory to query caching", in which case the attributes are effectively ignored and no query results are ever cached. Again, all this is indeed about 2 of several other forms of caching I'll discuss in my WebDU presentation. /Charlie http://www.carehart.org/blog/ -----Original Message----- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Duncan Sent: Sunday, March 04, 2007 6:24 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: CFQUERYPARAM was RE: [cfaussie] Re: @#$!! queryparam "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 -~----------~----~----~----~------~----~------~--~---
