I needed my Bot to check if the value of [UNIQUE ID] from Table-A is present in Table-B, and I always struggle with SELECT() and LOOKUP() type expressions, so I copied an expression from another post and modified to work with my table. Although the expression works, the Appsheet Expression Assistant shows the message: “Note: This expression could impact performance”. The current expression being used is:
IN( [UNIQUE ID], SELECT( DETAIL LOG 2023 [UNIQUE ID], TRUE))
Specifically, how would performance be affected, and can anyone suggest an alternate expression that will not impact performance?
You can pretty much ignore that message for anything Bot-related.
Also, that expression is fine.
2 Likes
Since you specified Bot-related, I should mention that I also used it as a Show_If expression in a form and saw the same message regarding impacting performance. Will using this expression in a form view impact performance in a way that’s noticeable to users, such as longer sync times?
A column show_if in a form is another case where you really don’t need to worry about that message, because the expression is only being run on a single record.
Though keep in mind that your column show_if may be evaluating in other instances besides just your form, like a table view, where it would need to be evaluated across all records being displayed. This could start to impact the responsiveness of the app/UI, though not greatly. It would not affect sync times.
Your expression is very simple. It’s evaluation speed would only increase linearly with the number of records in the “Detail Log 2023” table.
3 Likes
Thank you, Marc! I appreciate your time and the thorough explanation.
1 Like