Delineating Factors for Code Placement
I am not a fan of business rule rich stored procedures. However I am
against the grain on that thought in the organization that I work for.
What delineating factors should I use and present as to where we draw
the line on writing code in a stored procedures vs. development
language/tools (i.e. VB.NET, PowerBuilder, Delphi etc).
Can anyone point me towards a good chapter in a book or to an article
on the topic?
I am sick of looking through 500+ lines of "code" in stored
procedures loaded with conditionals. I cannot believe that writing the
same in a development environment is less productive.
I am not a fan of business rule rich stored procedures. However I am
against the grain on that thought in the organization that I work for.
What delineating factors should I use and present as to where we draw
the line on writing code in a stored procedures vs. development
language/tools (i.e. VB.NET, PowerBuilder, Delphi etc).
Can anyone point me towards a good chapter in a book or to an article
on the topic?
I am sick of looking through 500+ lines of "code" in stored
procedures loaded with conditionals. I cannot believe that writing the
same in a development environment is less productive.