On 1/5/2010 6:58 AM, Matt Blatchley wrote: > Would a Stored Procedure be better or faster in this > case?? >
Unfortunately the real answer is "It Depends". But as a general rule of thumb, moving as much of the data heavy lifting to the system designed to do heavy data work, aka a Database, is a good thing. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3258 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
