November 23, 2009 at 9:48 pm
Hi All,
Will there be any differences in terms of execution if i write complex functionality in single procedure or can i split them into multiple procedures.
November 23, 2009 at 10:32 pm
ManoharV (11/23/2009)
Hi All,Will there be any differences in terms of execution if i write complex functionality in single procedure or can i split them into multiple procedures.
Nope... usually no difference what so ever. But, it's really worthwhile if you can reuse some of those multiple procedures or you just want to split up some of the functionality so that you don't have to regression test a monster sproc if you make a change to just one part of it. Whatever you do, make those procedures handle more than one row at a time. They should solve problems as result sets... not individual rows.
--Jeff Moden
November 24, 2009 at 12:50 am
Thanks Jeff.
November 25, 2009 at 12:16 pm
Also splitting it up across multiple stored procedures will be more conducive to concurrent development within a team of developers.
November 25, 2009 at 10:51 pm
Unfortunately, that's not been my particular experience. I usually experience the ol' "too many cooks spoil the broth" syndrome.
--Jeff Moden
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply