Will, I believe that Stored Procs are more efficient since SQL will create execution plans for them, while for views, they have to be created for each execution.
Andy -----Original Message----- From: Will Tomlinson s With everyone's help I'm pretty much wrapping up the functionality of my clothing app/SQL Server db. I was planning on converting much of my SELECT <cfquery>s to stored procedures, and started reading some about views. Is a view equal to a stored procedure in performance? Does it matter at all which you use? Is one easier than the other? I'm trying to keep the load off of CF and place it on SQL Server since I'm using shared hosting. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190912 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
