Optimization of OData entity API

(1) Share

Report

Posted on by SA-20091232-0

Hi, I have created an Odata API of Sales orders, That is nothing but the copy of the default order headers API. We are trying to send information on orders to the other system, so it is being used as an outbound API. We are facing an issue in the optimization, as it returns records in thousands, and the modified orders are large. It takes approximately 3 minutes in every call to synch data to the portal(the other system), which gives timeout to the portal and synching data from D365 FO to the other system fails. My API does not have any extra joins, all are needed. How can I optimize it more, or is there any pagination kind of concept available to send data to the portal in chunks like if there are 5000 records available in the modified datetime >= 4th December , I want to send data in chunks of 1000, or suggest any of the best way to avoid the timeout situation.

Categories:

Microsoft Dynamics AX