Probably none. Preferred approach would be to use cfstoredproc as you can then return multiple resultsets which you cannot do with a cfquery.
-----Original Message----- From: Brian Peddle [mailto:[EMAIL PROTECTED] Sent: 16 January 2006 16:55 To: CF-Talk Subject: Performance Question Query Anyone know if there any performance difference between running a stored proc like this? <cfquery datasource="DSN"> Proc_test value1,value2,value3 </cfquery> As opposed to <cfstoredproc procedure="Proc_test " datasource="DSN"> .... </cfstoredproc> THANKS! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229680 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
