Coffeehouse Post

Single Post Permalink

View Thread: How big are your sprocs?
  • User profile image

    I try and keep mine small, but have seen some truly horrendous ones in my time that nobody seems to actually understand.

    But this is really a performance vs scalability question. You are pushing scalability but there are times where scalability isn't needed but performance is, and putting all the logic into a stored proc that gets called once rather than artificially using multiple stored proc invocations can make for much better performance.