Its too slow to sync MxModelReflection in ASU_

1
Hi. I need my MxModelReflection to always be up to date, because the subsequent actions in the ASU_ microflow rely on it. However, calling IVK_SyncObjects takes more than 1 second (and it also sends some UPDATE SQL commands although nothing is changed). Is it possible to run IVK_SyncObjects only when the schema really has changed? One idea is to compare lastsyncdate from mendixsystem$version , but I don’t know how to do that.
asked
2 answers
2

What we do is only updating the MxModel reflection if you do an action where the model reflection is used. So when a user wants to do an Excel import for instance we trigger this ASU flow. Because indeed doing it each time the model starts takes to much time.

Regards,

Ronald

 

answered
0

Or maybe an scheduled event with the microflow in it. And then trigger it to your liking.

 

Otherwise you should indeed compare the last sync date with the changed date of the objects in the modelreflection, like the MxObjectType entity.

You can store it in one object and keep comparing it every time.

That way you can trigger it if the sync date is older than the changed date

answered