Posted by Doug on 12/12/05 02:23

Everyone gets all excited about compile time. Compiling in my
experience has always been pretty insignificant compared to crunching
the data.

Like the man said, "it depends." I don't really like 1000 line SP's,
but have written and worked on a few. If you have a total of 5 10k
SP's, in a database, I'd argue that you could make things simpler by
breaking them into more reasonable logical pieces.
However, if you have 497 SP's, each 15 lines wrong, then I'd probably
argue that you could consolidate it somewhat for maintenance purposes.
All in all, if you are wading through a 1000 line Sproc, and reading
code to figure out what it is doing, then I'd argue strongly the
documentation sucks.

[Back to original message]