On The Insider: Britney's Bikini-Clad Top 10
BNET Business Network:
BNET
TechRepublic
ZDNet
TalkBack 15 of 33:
Next »
« Previous
My experience differs
From my experience store procedure are often an ingnored function in MSSQL and Oracle. The problem with stored procedures is it locks you into the database you are developing on. That means a lot more work.

I see far, far more projects that use stored procedures than those that don't. The problem you speak of is only an issue if you put too much business logic into your stored procedure. At that point I agree, it becomes a pain to migrate. Most of the projects I've been involed in use stored procedures for the performance (the SQL is precompiled and network traffic is reduced) and security (MUCH easier to secure a database if your logon doesn't have access to the base tables). You even get a slight advantage of shielding your application from minor database schema changes if you rely solely on stored procedures for CRUD. In all these cases your stored procedures are usually only 1 or 2 lines long and migrating is a tiny bit of grunt work that could probably even be automated.

When used in this way, lock in isn't a problem at all.
Posted by: NonZealot   Posted on: 02/05/05 You are currently: a Guest | Members login | Terms of Use
Reply to Story Reply to Message

Alert moderator to an offensive message

Subscribe to this discussion via Email or RSS

how many of these did they fix?  reid.thompson@... | 02/04/05
Was something broken?  The King's Servant | 02/04/05
Was something broken? YES  reid.thompson@... | 02/07/05
Hmmm  Linux User 147560 | 02/04/05
100% honest question  NonZealot | 02/04/05
Fewer Bugs Versus Simpler Application  jasonp@... | 02/04/05
Assumes a linear progression of bugs  NonZealot | 02/04/05
What about the severity of the bugs?  Hugh Jass | 02/04/05
lint and char[256]  hipparchus2001 | 02/04/05
Don't forget  seosamh_z | 02/06/05
Um, never....  Jomo_z | 02/07/05
Would this mean...  Mack DaNife | 02/07/05
Well..  d_jedi | 02/04/05
Stored procecures aren't used often  voska | 02/05/05
My experience differs  NonZealot | 02/05/05
Not with "in house" projects  toadlife | 02/05/05
Spoken like a true technotard  Chad_z | 02/04/05
Chad, your noise is missing the point  DePiep | 02/05/05
Chad the Great  seosamh_z | 02/06/05
MySQL is a companies product  B.O.F.H. | 02/06/05
RE: 100% honest question  richdave | 02/05/05
This isnt a troll...  vdraken | 02/04/05
The comparison is...  The King's Servant | 02/04/05
I was so concerned.....  michael-t | 02/04/05
Few bugs.. I don't think so!  d_jedi | 02/04/05
and your point is? nt  michael-t | 02/04/05
Isn't Coverity typical commercial code?  gsbtech | 02/04/05
Linux ratio is 1/17,000, not 10,000  DePiep | 02/05/05
Courage.  richdave | 02/05/05
YA GOTTA BE KIDDING ME!!  Xunil_Sierutuf | 02/05/05
Finally!  Outside T. Box | 02/07/05
Another cheap marketing gimmick  tpepernic | 02/05/05
"Commercial Code"?  Rodney Davis | 02/07/05

What do you think?

SponsoredWhite Papers, Webcasts, and Downloads

advertisement
advertisement

IT Solutions for 2010

  • Get cost-effective strategies and roadmaps on the most important issues facing IT leaders in 2010! Learn how to easily cut costs and deliver greater efficiency starting with your database, IT compliance management and data center. Visit the IT Leaders Dashboard. Visit the IT Leaders Dashboard.
  • Read about top issues IT decision-makers face every day, plus get cost effective solutions to real life IT problems. Oracle Topline