Anyone know if there is an advantage either way when it comes to calling a stored procedure?
Say I have a storedproc called GetAllResults. I can call it 2 ways. <cfquery name=myquery datasource=mydatasource> Execute GetAllResults </cfquery> <cfdump var="#myQuery#" /> Or <cfstoredproc datasource="mydatasource" procedure="GetAllResults"> <cfprocresult name="myquery" /> </cfstoredproc> <cfdump var="#myQuery#" /> CFquery seems to be faster to me. I just wondered what everyone else thought about it and if there was an advantage or disadvantage either way that I dont know about. Oh, I also thought it was funny that cfquery was only faster than cfstoredproc when cfquery was NOT cached odd. ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield ColdFusion Application Developer HYPERLINK "http://acoderslife.com"http://acoderslife.com -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.441 / Virus Database: 268.18.3/697 - Release Date: 2/22/2007 11:55 AM ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270462 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4