[EMAIL PROTECTED] wrote:
>
> I asked this question and quite a discussion broke out between the DB
> heavyweights (Jochem and Adam I think)
Thank you :-)
> I've tried my best to find it in the archives but I can't for some
> reason.....
http://www.houseoffusion.com/cf_lists/index.cfm?method=messages&threadid=24110&forumid=4#121513
I hope I am doing Adam's position justice when I summarise the
debate as follows:
- with cfqueryparam, changes in the value of a parameter will not
lead to a recompilation (overhead) of the query execution plan in
the DBMS
- this is genarally a good thing, because it means a query like
select * from table where id = X gets only compiled once,
regardless of the value of X
- therefore, if you use cfqueryparam for constants as well, the
query will still be only compiled once (Adam)
- but if you don't use cfqueryparam, you can force a
recompilation of the query execution plan if you want so (Jochem)
I am still not sure we actually disagree :-)
Jochem
--
When you don't want to be surprised by the revolution
organize one yourself
- Loesje
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
- The Value of CFQUERYPARAM Ian Skinner
- RE: The Value of CFQUERYPARAM Tom Kitta
- RE: The Value of CFQUERYPARAM d.a.collie
- RE: The Value of CFQUERYPARAM Shawn McKee
- RE: The Value of CFQUERYPARAM Ian Skinner
- RE: The Value of CFQUERYPARAM Tom Kitta
- RE: The Value of CFQUERYPARAM Lofback, Chris
- RE: The Value of CFQUERYPARAM d.a.collie
- RE: The Value of CFQUERYPARAM Jochem van Dieten
- RE: The Value of CFQUERYPARAM Dave Watts
- RE: The Value of CFQUERYPARAM Shawn McKee
- RE: The Value of CFQUERYPARAM Ian Skinner
- RE: The Value of CFQUERYPARAM Philip Arnold
- RE: The Value of CFQUERYPARAM Raymond Camden
- RE: The Value of CFQUERYPARAM Barney Boisvert
- RE: The Value of CFQUERYPARAM Shawn McKee
- RE: The Value of CFQUERYPARAM Ian Skinner
- RE: The Value of CFQUERYPARAM kpeterson
- RE: The Value of CFQUERYPARAM Gaulin, Mark