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)