> From: Michael Dinowitz [mailto:[EMAIL PROTECTED] > Thank you for pointing that out. It looks like I missed that. > So basically, the order of cfprocparams being passed is all > that matters and no parameter can be missed when writing > cfprocparam tags. > > Is there any performance (i.e. binding) savings to using the > CFSTOREDPROC tag vs. a CFQUERY with CFQUERYPARAMs? Is the > CFSTOREDPROC call as efficient? > Better? What's the advantage? Anyone from MM want to comment? > Thanks
One major advantage of using the cfquery tag to call the stored procedure is the fact that you can use the cachediwthin and cachedafter attributes whereas cfstoredproc does not have them. Michael T. Tangorre ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188418 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
