we are having a performance issue with our apps, the app shows the following alert:
“The condition of format rule ‘Médicos’ may be expensive and slow the user experience of your app”
We have identified that the alert is because of this formula:
OR(LOOKUP([_THISROW].[Médico],Médicos,Médico,Classificação) = “1”, LOOKUP([_THISROW].[Médico],Médicos,Médico,Classificação) = “2”)
but we do not identify what is causing the problem in this formula, does anyone have any suggestions for improvement in this formula?
Are you looking up the value of a column in another table rather than the table that you are applying the formatting rule?
I mean is “Médicos” table the same table that this rule is applied?
Format rules are applied in real time to the rows included in the on-screen view. If your tables are large, the expressions used by your filter rules could take a lot of time to compute and slow the app. For this reason, it’s a good idea to keep format rule expressions simple and (as @LeventK is getting at) to avoid filter rule expressions that use other tables.
Yes, the table “Médicos” is in the same table of the rule.
This problem has started recently and this formatting rule has always existed in our app.