Actually, in my experience using stored procedures provides negligible speed improvements over cfquery. This is due to the fact that modern databases cache execution plans and support prepared statements. There are reasons one might want to use stored procedures, but speed increases over cfquery isn't one of them.
On 7/26/07, Robert Harrison <[EMAIL PROTECTED]> wrote: > > > Interesting, I've always thought that CF connections to a database > should > be improved: > > That cool, but any speed issues with CFQUERY are easily overcome by using > stored procedures. Been trying to move the them as much as possible. > > > Robert B. Harrison > Director of Interactive services > Austin & Williams > 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 > T : 631.231.6600 Ext. 119 > F : 631.434.7022 > www.austin-williams.com > > Great advertising can't be either/or... It must be &. > > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.5.476 / Virus Database: 269.10.20/919 - Release Date: 7/26/2007 > 9:56 AM > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284651 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
