Faster Datawindow Object References

You can get better performance by using a DWObject variable to resolve the object reference in a Datawindow property or data expression. Evaluating the reference once and reusing the resolved reference is more efficient than fully specifying the object reference again. This technique yields the most benefit if you are using a Datawindow expression in loop. For example the fully specified data expression within the loop must be resolved during each pass:

Integer li_Data, li_I

FOR li_I = 1 to 100
        li_Data = dw_1.Object.emp_salary.Primary[ li_I ]
        .. // Code to process data value
NEXT

The following code uses a DWObject reference and has better performance:

Integer li_Data, li_I
DWObject dwo_EmpSalary

dwo_EmpSalary = dw_1.Object.emp_salary.Primary

FOR li_I = 1 to 100
        li_Data = dwo_EmpSalary[ li_I ]
        .. // Code to process data value
NEXT

Back