in a microflow for overview , trying to change value of certain attributes ( only 2 out of 50 ) on 100 records . So i do a change object to change these values against iteration of all 100 records to show on the overview page. i see the data has been changed in the database within a second or two , but the overview page shows the data only after a minute. even thought data has changed in database, there are queries running which i think has to complete before mendix shows the overview page data. trying to understand why would so many queries run when only im updating the 2 attributes. all i need is to update 2 attributes in 100 rows..
I tried committing and not committing inside the loop, both result in same performance..Committing the SubmitMainData list outside of looop.