>>ColdFusion creates a temporary stored procedure on the server, then executes that temporary stored procedure.
Does CF create that temporary stored procedure every time a single CFQuery is called? It seems like a bit of extra overhead. Curious, G! On Sun, Aug 8, 2010 at 10:47 PM, Mike Chabot <mcha...@gmail.com> wrote: > > 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:336104 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm