By: Ray West on Friday, February 8, 2008
As a web application gets larger and needs to handle more traffic, special attention is needed to make sure it is running as efficiently as possible. More often than not, that means taking a look at the way that your data is marshaled from the database. I am constantly amazed at how much effort can be placed in making sure that pages are only so heavy and take X seconds to load on the HTML side, when very little consideration is given to how the database is being accessed.
The two things to remember when dealing with the optimization of your database are minimizing network traffic, and the reuse of execution plans. Both of these are accomplished by the proper use of stored procedures. In this article, we will cover a few tips to help you get the most out of your stored procedures.