| Author |
Topic |
|
sqllearner
Aged Yak Warrior
639 Posts |
 Posted - 2006-08-25 : 18:54:38
|
| Will the number of input and output parameters in a stored procedure cause any performance issues.Because in all my stored proc have @sp_name VARCHAR(100) OUTPUT, @parameters VARCHAR(500) OUTPUT, @action CHAR(10) OUTPUTwhich I need for error handling.Please let me know |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-08-25 : 20:01:22
|
it will not affect the performance of stored procedure. If you have performance issue with the stored procedure, you should be looking at the query in the stored procedure
KH |
 |
|
|
sqllearner
Aged Yak Warrior
639 Posts |
Posted - 2006-08-25 : 21:00:30
|
| Thanks a lot... |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-08-26 : 00:46:22
|
| Are you using Dynamic SQL?MadhivananFailing to plan is Planning to fail |
|
|
|
sqllearner
Aged Yak Warrior
639 Posts |
Posted - 2006-08-26 : 03:55:43
|
| No Iam not using dynamic query but iam using one cursor which calls around 35-40 stored procedures |
|
|
|
sqllearner
Aged Yak Warrior
639 Posts |
Posted - 2006-08-26 : 14:50:33
|
| Will this cause any perfomance inssue |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-26 : 19:57:11
|
| Yes your cursor and calling of all of those stored procedure will be a performance issue.Tara Kizer |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-08-26 : 22:10:14
|
You should consider rewrite the 35-40 stored procedures if the performance is really bad and an issue.
KH |
|
|
|
sqllearner
Aged Yak Warrior
639 Posts |
Posted - 2006-08-27 : 04:13:10
|
| But will the no of input and output parameters cause performance issue |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-08-27 : 04:45:12
|
No. As Tara said, It is the cursor and calling of all these SP.
KH |
|
|
|
|
Stored Procedure Parameters