Optimization on SP calls based on the number of parameters

areza123 · Jun 16, 2003

I'm calling an SP from my c++ code. The SP takes 3 parameters which are all varchar(50). Will it run faster if I replace this with 1 parameter ?

Thanks

JeanNiBee · Jun 17, 2003

Hi

In general, no, but it totally depends on what the sp is doing.

-=-=-=-=-=-=-=-=-
For ease of reading, any posted CODE should be wrapped by [ignore][COLOR][/COLOR] and

Code:

[/ignore] tags.

Ex:

Code:

SELECT 1 from sysobjects

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Optimization on SP calls based on the number of parameters

areza123

Programmer

JeanNiBee

Programmer

Similar threads

Part and Inventory Search

Sponsor