--- Jochem van Dieten <[EMAIL PROTECTED]> wrote:
> Duncan I Loxton wrote:
> > While I am here - I have read that using cfqueryparam gives a
> > performance gain over not using it - is there any proof or technical
> > data out there? An explanation over why/how it makes a query faster?
>
http://www.google.com/custom?q=cfqueryparam+execution+plan&sitesearch=houseoffusion.com
I try to use queryparams whenever possible, but I have had occassions
where using it resulted in a performance degradation using Oracle 9i.
No rhyme or reason I can see, but I did have to remove the queryparam to
get better performance on the query. YMMV.
__________________________________
Do you Yahoo!?
The all-new My Yahoo! - What will yours do?
http://my.yahoo.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189502
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
