Try not to think about queryparam as a performance benefit so much, The performance increase isn't really anything that massive, think about it from a security perspective.
Without cfqueryparam people will add, edit and remove content from your database, gain access to secure sections of your site, steal important information from you, names, address, credit card information and so on. queryparam really is important... _really_ important ... I can't stress that enough. Why is it that you find it annoying? Because of the extra few moments it takes to code? It really is worth that extra few seconds to wrap up all your dynamic parameters, once you get in to the habbit you won't even think twice about it. Rob -----Original Message----- From: Ben Mueller [mailto:[EMAIL PROTECTED] Sent: 24 October 2007 17:33 To: CF-Talk Subject: Re: cfqueryparam and dynamically-created SQL Thanks, all, for your replies. So, a follow-up question: will SQL create multiple prepared statements for each condition? If so, that's great. My fear is that it will only create 1 prepared statement for each cfquery block, so if the current statement doesn't match the previous statement, it would discard the previous one and create a new one. I have a bunch of queries that have 8 or more <cfif> conditions, almost all in the WHERE clause. Obviously, the more <cfif> conditions there are, the greater the likelihood that any one individual call won't match the previous one. I know cfqp is really good and all that, but this would be pretty annoying if I got no real performance benefit. > >Yes, to the extent that you are less likely to have another query with the >same prepared statement (and the same execution plan, of course) that can be >run again. Frankly, though, I wouldn't worry too much about that, since >coding around that causes all kinds of problems. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291981 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
