I run almost all my queries with queryparam so they're all precompiled anyway. When I do a trace, I see that sqlserver is calling that query as an sp after the first call. Therefore, I get the benefits of speed of the sp with the ease of deployment with cf.
On 8/27/06, Teddy Payne <[EMAIL PROTECTED]> wrote: > Even for small queries, the execution time will typically always be faster > executed from a databse like MS SQl, Oracle ..etc than from the CF server. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251199 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4