
Yay or nay - expression properties on a model
Hi all,
I found out (the hard way) that we should be careful when using expression properties on a model as it can fill up our queues performing - unnecessary - updates. We are now very reserved as it comes to using these properties only using them when no other option is possible. We now flatten the calculated results and update when it should be updated.
We want fields to be updated based on more complex update rules so I am reconsidering this option.
What are your experiences with expression properties especially with larger datasets and frequent updates? Should these only be updated when one of the fields used are updated or is other logic used?
Jeroen
Hi all,
I found out (the hard way) that we should be careful when using expression properties on a model as it can fill up our queues performing - unnecessary - updates. We are now very reserved as it comes to using these properties only using them when no other option is possible. We now flatten the calculated results and update when it should be updated.
We want fields to be updated based on more complex update rules so I am reconsidering this option.
What are your experiences with expression properties especially with larger datasets and frequent updates? Should these only be updated when one of the fields used are updated or is other logic used?
Jeroen
Login to reply