0

Dear all, I know that for a better performance when retrieving a lot of data from database and processing it, it is better to use Batches (https://academy.mendix.com/link/module/21/lecture/85/3.3-Using-Batches) and retrieve for example 250 items at once, and than another 250 and so on. In my case I have an OData API and receiving about 2800 items. I am using the “$skip” and “$top” and “$orderby” parameters to retrieve 100 items at once and process it in an microflow (let’s called it “refresh list”). The microflow “refresh list” ends as soon as the OData API call sends an empty list. Refresh List microflow looks like this: Get 100 Items (produces memory cache) Process 100 Items (which for sure also creates extra memory cache) Commit 100 Items to the database (now I thought the memory should be empty) Continue with step 1 as long the list ist not empty, otherwise end microflow   What I also remember is that I might read in the community forum that the microflow has to end so that the memory cache gets emptied. How could I do that in my case? Would it be enough to call the relevant activities as a submicroflow?        

asked 2021-01-15

2 answers