Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Stored Procedures ,,,pros and cons

 
Alan Hermin
Ranch Hand
Posts: 290
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi all..

i read some articles from internet about Stored Procedures,many of them told us that Stored Procedures is not good and it is bad....
i want to stat my new application..and i will not use it if it is bad..
can you tell me if these article true..???/



Regards
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Very few things are inherently good or bad in IT. The biggest disadvantage of a stored procedure is that it ties you to a specific database.
 
Scott Selikoff
author
Saloon Keeper
Posts: 4033
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Good if you know without a doubt: 1) you will never switch databases 2) you will never need to rewrite the procedure.

The problem with them is if you write too many (hundreds) trying to update them later for small changes or new databases can be nearly impossible. In general, I try to avoid them at all costs unless they are absolutely needed (usually when large chunks of the database are required for a calculation such that performing in client-side would not be possible or would require downloading to much data). Even then I try to avoid such problems with de-normalization and caching.
[ April 15, 2007: Message edited by: Scott Selikoff ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic