Small methods - Small sprocs
Posted
by
Berlioz
on Stack Overflow
See other posts from Stack Overflow
or by Berlioz
Published on 2011-01-05T14:44:01Z
Indexed on
2011/01/05
14:54 UTC
Read the original article
Hit count: 298
Uncle Bob recommends having small methods. Do stored procedures have an ideal size? Or can they run on for 100's and 100's of lines long?
Also does anyone have anything to say about where to place business logic. If located in stored procedures, the database is being used as data processing tier.
If you read Adam Machanic, his bias is toward the database, does that imply long stored procedures that only the author of the sproc understands, leaving maintainers to deal with the mess?
I guess there is two inter-related questions, somehow.
Thanks in advance for responding to a fuzzy question(s).
© Stack Overflow or respective owner