SQL Server Performance

Global Variables slow performance

Discussion in 'SQL Server DTS-Related Questions' started by Khek, Jan 23, 2004.

  1. Khek New Member

    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.

Share This Page