Format rule may be expensive and slow the user experience of your app

Hi,
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?

@Dev_TI
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?

2 Likes

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.

1 Like

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.