Handling the list with huge count, system is being overloaded.
Hi , I’m reading a file and converting all the lines into a list( mendix objects) using java action. With that list I have a scenario where I need to iterate all the list, check for some conditions and create new objects for each iterated object. The functionality is all good when I have the list count in thousands, but I have file with 10 lakh lines. So iterating all this, the system is being overloaded and getting stuck. What is the best way to handle this situation. Thank You.
Try to create batch processing, after each batch, clear unused lists. And do some research on "EndTransaction”, that could be helpful as well.
Or use the java action "CommunityCommons.executeMicroflowInBatches”