Replace all if possible... Patches all security holes that way... If you have any queries that rely on parameters, you potentially run the risk of having someone alter your data. Also, the execution plan is saved, thus saving you time in parsing the query. Performance gain, security... Is there any reason not to?
-----Original Message----- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Friday, December 07, 2001 10:45 AM To: CF-Talk Subject: Correct Usage of Stored Procedures What's the best practice is using stored procedures, should they replace all queries or just complex queries? Thanks, Dave ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
