Business Logic in Stored Procedures is bad!

Four months of struggling with fragmented business layers have helped me to understand through experience what I already knew in theory: placing business logic in stored procedures without a valid reason is simply bad! For systems that are deployed once and then left alone this could be fine! But for those systems where the business rules and the developers involved change frequently this can lead to a codebase that is a nightmare to deal with! Here are a few links that tell you why:

Beating a dead horse: Stored Procedures
Mind your PQs
Stored procedures are bad, m’kay?
Good and Evil in the Garden of Stored Procedures
Why I do not use Stored Procedures

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s