Performance of Output Parameter

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 398910 More actions · Answer 1

Are you asking if output parameters are slow? No, they're not. If anything, they can be faster than returning a result set.

Are you asking if large numbers of output paramters can hurt performance? That, I don't know. It's not something I've tested.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

ghanshyam.kundu Hall of Fame Points: 3337 More actions · Answer 2

ya, my question is large no. of output parameter hurts procedures performance if yes then why ??

Grant Fritchey SSC Guru Points: 398910 More actions · Answer 3

I don't know. It's something I'd have to test. You need to let us know what a "large number" looks like to you.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt