SQL Server Performance Forum – Threads Archive

Global Variables slow performance

Gentelmen, Could you please explain loss of performance of appr. 12-15% when reading values from global variables compared to hard-coded values:
I import large text file concatenating come field value with some constant string value (e.g. "XXX") which I’d like to store outside of DTS package. I noticed that going thru hundreds of thousands of lines from text file and concatenating a certain field with a value read from global variable (DTSGlobalVariables("gvName").Value + DTSSource("Col010")) I get a 12-15% slower performance than when specifying constant right within code ("XXX" + DTSSource("Col010")). Thanks in advance.

---

]]>