> case?? I've been reading that there are two schools of thought > on the subject. Either use SP's all the time or don't. But > that was written in 2006, am I missing somthing?? Any thought's, > insights, or opinions would be greatly appreciated!
The "all or nothing" mentality comes from a debugging perspective. Your application becomes a lot more difficult to debug and maintain with some SQL in the code and some tucked away in the database. Generally speaking, putting the SQL into the database will be more efficient as long as the queries are well written. It's also safer than generating raw SQL from within the code to prevent SQL injection attacks and the like. Using CFQUERYPARAM within the code will give you some of these benefits as well without having to resort to a full on stored procedure. It's really a matter of what's most important to you. If raw performance is on the top of the list, test it both ways and use whichever produces the best result. -Justin Scott ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:3257 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
