I wouldn't say that ORM systems have an "obvious advantage" in every situation. There are plenty of good reasons to use stored procedures that have nothing to do with efficiency. ORM systems and stored procedures are not mutually exclusive. Many ORM systems allow you to use stored procedures.
If I were in your position I would probably follow instructions and not fight the battle. Stored procedures work well and using them shouldn't cause much disruption. Most people don't realize that when you send a parameterized query using cfquery to SQL Server, what happens behind the scenes is that ColdFusion creates a temporary stored procedure on the server, then executes that temporary stored procedure. Even people who don't like using stored procedures are using them without realizing it. :) Enjoy, Mike Chabot http://www.linkedin.com/in/chabot On Sat, Aug 7, 2010 at 10:51 AM, Matthew Allen <a.matthe...@yahoo.com> wrote: > > This is rather annoying, the software development manager of the company I > work for decreed yesterday that all (I mean ALL) web application we write in > house from yesterday on, must now all be stored proc. No more inline-SQL and > no more ORM because of one badly written ORM by a member of the team. > > He has one valid reason in that we have one or two (not the majority of) > applications having the need to access data from different platforms (.NET, > PHP and CF). > > Does he really have a solid argument when he said that ORM compared to Stored > Proc and inline SQL is really in-efficient? In his previous life he was a > DBA, is he stuck in the past? or am I paranoid to think that he is only > keeping his options open, options open in the sense that, strategically, he > does not want to be tied to CF or is it really true that ORM's despite its' > obvious advantages is not great compared to stored proc? > > Thanks > > Matt > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336103 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
