SBX - Finance Heading

QueryExpression and how to boost the performance!

Options

In my current company. We have a custom program that will process huge load data. Per running, it can process around 50.000 records and avg finished can be more than 3 hours ++. After I check, one of the thing that make this slowness is because of retrieving process.

The problem with that code is we retrieve the Orders, but separately retrieve Contact entity. Using this way, the program need to retrieve one by one the Contact based on ContactId that supplied by the Order. For reducing taking one by one the Contact entity, we can achieve it using AddLink (join).