Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) 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
Sheriff
Posts: 35976
422
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
Bartender
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 ]
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!