The performance benefits that SPs bring are based around their ability to act on a query result without having to send the resultset back across the network to CF. I.e. if I have to do two queries and the second depends on the results of the first, an SP will most likely be more performant, because it only requires two network trips, rather than four, and one CF recordset creation, rather than two. This effect obviously increases with the more complex the interactions are, especially if the first recordset would have been large, and isn't needed except for use in the second query.
If you just have a simple query, there's not really anything that an SP can do to speed it up that isn't going to happen anyway. And then there's the overhead of calling the SP itself, which doesn't exist in a simple query. cheers, barneyb On 10/30/05, Brian Peddle <[EMAIL PROTECTED]> wrote: > You mention SP's will give greater performance. I think that may be a myth > these days. Google around and you will find all sorts of debates on it. I > was shocked myself after spending a good bit of day taking some queries from > a CF page and dumping them into a shiny new stored proc and things didn't > improve and actually seemed to slow down some. > > Here is one link http://weblogs.asp.net/fbouma/archive/2003/05/14/7008.aspx > but there are many. > > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222680 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
