0 Replies Latest reply: Apr 8, 2011 11:49 AM by Sandip1981 RSS

    VBS macro runs very very slow :(

      I have VBS function in a macro as below to retrieve information by passing parameter.

      Function GetAdd(strPostCode)

      Set aobj = CreateObject("PCSoftware.Address")

      aString = aobj.Address(strPostCode)

      GetAdd = aString

      Set aobj = Nothing

      End Function

       

       

      And I call that function at load time as below.

      TempNewAdd:

      LOAD

      SpaceID,

      GetAdd(PostCode) as NewAdd

      RESIDENT InputAdd;



       

      Now my problem is when I run above function from externally(command prompt) it take less than 1 minute to process about 1000 records

      but when I run it in QlikView it take 2 hour.

       

      Any idea why such huge difference???

      (I am using QT10 64bit)