Performance Issue

Question

Hi,
In my application there are around 180 tables. I have created stored procedure for Insert, Delete, Update, and Retrieve functionality. These procedures have single line statement i.e for insert into table Insert command and all field values as parameters.
Now my query is related to performance. If i use same query using SqlCommand in c#
then which way is efficient performance wise.

Nilanka Dharmadasa · Accepted Answer

Hi Vikram,
As I see, there is no change in efficiency between the tow methods as it's only a simple query. But using stored procedures is good as you have youe query seprately.
Then if you have any modification in the query, you can do that without changing your code or building  your project again.
Hope you got my point.
If you need more info, go to this link.
http://searchsqlserver.techtarget.com/news/article/0,289142,sid87_gci1052737,00.html #
If you find my answer useful, please accept my answer.
Thanks.

Vikram · Answer

Hi Niki,
Thanks for your reply, same query means instead of stored procedure if I use SqlCommand in C# to Insert record into Database. Which way will be efficient.

Nilanka Dharmadasa · Answer

Hi Vikram,
Your question is not clear for me.
What do you mean by 'same query'?
You have separate procedures for each table or you use same procedure?