Performace Issue

I have one scenario I wanted to know wheather it will cause slow performance or not we have a local entity and we are syncing Odata entity data into this local entity via scheduler on daily basis(can't change or reduce this interval). So any changes in entry of  odata entity will only reflect in local entity after 1 day, suppose to avoid this Instead of local data retrieval if i retrieve Odata directly in  microflow will it cause performance issue? Because I have such type of atleast 6-7 microflow and each microflow i am retrieving 3-4 times Odata.        
1 answers

Based on my understanding of your question you are syncing data with SAP on a daily basis. For this, I would give the sync task to a Task Queue and execute it in the background.

In that case, the UI is not slowed down and can perform another action. However, if the data that is synced is critical for the process, you would wait on it. Task Queues can run over multiple threads and nodes. In SAP, you can check if the setting of the task queue is not causing a performance issue.


Another optimization is to only sync the objects that were changed since the last synchronization. For this, you can use various techniques.


To advice better, I should get more details.