Change Object performance question
4
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..
asked
JP
3 answers
0
I tried committing and not committing inside the loop, both result in same performance..Committing the SubmitMainData list outside of looop.
answered
JP
0
here is the latest flow..
answered
JP
0
timer set at start and end.
start variable, microflow_start : [%CurrentDateTime%]
end variables , just before end of microflow :
toString(secondsBetween($microflow_start,[%CurrentDateTime%]))
answered
JP