Spliting sprocs into seperate sprocs to improve performance


I have a reasonably small sproc that depending on what optional attributes you pass in (exisiting ID or account ID) it gives a unique identifier back. It will be hit alot (100 times a min, maybe upto 300 in peak times).

Performance wise does it make much of a difference for performance if I split this out into two seperate sprocs - one for exisitng ID and another for account ID in a MS SQL DB 2014? Im hesitant to do so unless there is a performance improvement and it would mean duplicated code in the sprocs. At the moment I’m just using if statements to do both in the one sproc.


“premature optimization is the root of all evil” – Sir Tony Hoare (popularized by Donald Knuth)

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.