Parameter Passing and Performance
June 20, 2007 Ted Holt
There are three ways to pass a parameter to a procedure: by reference, by value, and by read-only reference. These methods are not interchangeable, and passing parameters by value can have unfavorable effects on performance. In the following paragraphs, I explain why I make such a statement, I show you how to define parameters for performance, I list the performance figures from my testing, and I provide some recommendations for parameter passing.
Before I go any further, let me get a couple of things out of the way. First, keep in mind that I am talking about you and the