Microflow Loading time is large for huge number of records

4
Hi Everyone, Iā€™m having a huge set of records that I need to iterate and need to find the sum of all the records which I need to store in one attribute, but the microflow loading time is taking more than an hour, is there any other solution to resolve For example List one ā€“ 27 records List two ā€“ 157 record 27 records need to iterate 157 times each to find the sum.   Thanks in advance
asked
2 answers
2

Hi ajitha,
following best practice to optimizing your code 
https://docs.mendix.com/howto/monitoring-troubleshooting/detect-and-resolve-performance-issues#optimizing
and you can also check the microflows loading time where it take time to load 
https://docs.mendix.com/howto/monitoring-troubleshooting/detect-and-resolve-performance-issues#4-3-microflow-time-stamps 
 

answered
1

Hello Ajitha,

Please take a look at https://docs.mendix.com/refguide/aggregate-list and  https://docs.mendix.com/howto/logic-business-rules/optimizing-microflow-aggregates to see if this can be a solution to your use case.

answered