|Ned Batchelder : Blog | Code | Text | Site|
Stored procedures: good or bad?
» Home : Blog : November 2004
In my experience, this debate comes down to a mindset. If you are fundamentally database-focused, you will like stored procedures. If you are fundamentally application-focused, you will not. Generally, requirements like portability and maintenance costs will outweigh personal preferences any way. For example, if your application has to run on more than one database, stored procedures will be very expensive to use (because they will have to be re-written for each database platform). Personally, I find writing code in pre-paleolithic SQL extensions to be absolutely abhorrent, so I don't like stored procedures. Some day, maybe I'll work on a project where their benefits outweigh their disadvantages.