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.
1 answers

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”