Variable Initialization Performence

[FrankBradley]

Is it possible to reduce the time required to perform the initial variable instantiation. We have been watching the process and to load the 38 variables from the $Filedata Column()$ area into the working fields takes some time. Once the instantiation has been done each subsequent pass has no delay.



Read From CSV file : '$InImportFileName$' Delimiter: 'Comma' Header: 'No'
Start Loop " Each row in a CSV/Text file"
Comment: Use $Filedata Column$ variable for each record in File.
Variable Operation : $Filedata Column(1)$ To $InCustomerEmail$
Variable Operation : $Filedata Column(2)$ To $InCustomerTitle$
Variable Operation : $Filedata Column(3)$ To $InCustomerFirstName$
Variable Operation : $Filedata Column(4)$ To $InCustomerLastName$
Variable Operation : $Filedata Column(5)$ To $InCustomerPhoneNumber$
Variable Operation : $Filedata Column(6)$ To $InCustomerPhoneNumberExt$
Variable Operation : $Filedata Column(7)$ To $InCustomerMobile$
Variable Operation : $Filedata Column(8)$ To $InCustomerStreet$
Variable Operation : $Filedata Column(9)$ To $InCustomerCity$
Variable Operation : $Filedata Column(10)$ To $InCustomerProvince$
Variable Operation : $Filedata Column(11)$ To $InCustomerPostalCode$
Variable Operation : $Filedata Column(12)$ To $InLeadNumber$
Variable Operation : $Filedata Column(13)$ To $InCustomerPurchaseId$
Variable Operation : $Filedata Column(14)$ To $InCustomerEnteredBy$
Variable Operation : $Filedata Column(15)$ To $InCustomerCreatedOn$
Variable Operation : $Filedata Column(16)$ To $InCustomerPaymentOrder$
Variable Operation : $Filedata Column(17)$ To $InCustomerPaymentMethodId$
Variable Operation : $Filedata Column(18)$ To $InCustomerPaymentTypeName$
Variable Operation : $Filedata Column(19)$ To $InCustomerCardHolderName$
Variable Operation : $Filedata Column(20)$ To $InCustomerCardNumber$
Variable Operation : $Filedata Column(21)$ To $InCustomerExpiryYear$
Variable Operation : $Filedata Column(22)$ To $InCustomerExpiryMonth$
Variable Operation : $Filedata Column(23)$ To $InCustomerAccountName$
Variable Operation : $Filedata Column(24)$ To $InCustomerCheckNumber$
Variable Operation : $Filedata Column(25)$ To $InCustomerAba$
Variable Operation : $Filedata Column(26)$ To $InCustomerAccountNumber$
Variable Operation : $Filedata Column(27)$ To $inCustomerAmount$
Variable Operation : $Filedata Column(28)$ To $InArticleDiscount$
Variable Operation : $Filedata Column(29)$ To $InCustomerDeffered12Month$
Variable Operation : $Filedata Column(30)$ To $InCustomerEqual24Payments$
Variable Operation : $Filedata Column(31)$ To $inCustomerAuthorizationNumber$
Variable Operation : $Filedata Column(33)$ To $InArticleNumber$
Variable Operation : $Filedata Column(34)$ To $InCustomerDate1$
Variable Operation : $Filedata Column(35)$ To $InCustomerDate2$
Variable Operation : $Filedata Column(36)$ To $InCustomerDate3$
Variable Operation : $Filedata Column(37)$ To $InCustomerDate4$
Variable Operation : $Filedata Column(38)$ To $InStoreCode$

Any ideas

[forumsupport]

Hello,

The exe generally runs faster than the task so what we suggest is either you increase the delay time or you can also create the custom delay. For e.g. if the results are coming up in a window then you can put up a loop to wait until that particular window exsists. After you have a look at the results, close that particular window so the task will come out of loop (wait condition) and will execute the following commands of the task.

Hope that helps.

[FrankBradley]

Originally Posted by forumsupport

Hello,

The exe generally runs faster than the task so what we suggest is either you increase the delay time or you can also create the custom delay. For e.g. if the results are coming up in a window then you can put up a loop to wait until that particular window exsists. After you have a look at the results, close that particular window so the task will come out of loop (wait condition) and will execute the following commands of the task.

Hope that helps.

The issue is the time it takes for your software to initialize the variables. We do not want to have an increase in this time which is what you have just suggested.

[forumsupport]

Hello,

Create exe of the task that would run faster as all the required files are packed in it so the resources are free.