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.