Alex Rivera | Logout

Do Stored Procedures really boost performance in MS SQL / .NET?

Asked 2008-11-08T05:41:01.843
29

Jeff Atwood wrote about this here, and while I understand the theoretical performance boost a stored procedure could offer, it does seem like a tremendous pain.

What types of queries would you see the most performance increase using stored procedures, and what types of queries would you rather just build on the fly?

Any documentation one way or another would be greatly appreciated.

.net sql-server performance stored-procedures
Edit
Report

1 Answer

0

The idea behind Stored Procedures being faster is that they can store cached query plans, kinda like precompiling the stored procedure. So if the procedure is very complex with lots of joins between lots of tables you may see a speed benefit.

I think stored procs are desired for more than their speed, they help abstract the database schema and help to prevent sql injection attacks.

answered 2008-11-08T05:44:42.803

Your Answer