Re: stored procedures

[Steven Brownlee]

Stored procedures are not meant to replace simple queries that have negligible affect on the server - queries that return a small amount of rows, or queries on tables with few indices.  However, when your application becomes heavily data-dependant and complex then moving those queries to the database layers will drastically reduce the processing time on the server versus using CFQUERY.  Stored procedures are precompiled on the database layer and optimized for that particular engine.

In addition, stored procedures can help maintain a better level of security and better type control on input and output parameters.

For the majority of simple Internet or Intranet applications built by ColdFusion developers, stored procedures are overkill, but once you take it to the next level, they become your best friend.

> hey this might sound lame to some of you that use stored procedures
> and i apologize, but what is the point or what is the benefit rather?

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

---