Will this speed up sync time?

[Daniel_Turner]

I use security filters for almost all my data sources. Each of these formulas uses a value calculated from one table (Table A). So, each security filter is recalculating the same value (from Table A) and then using it in the security filter. Would be it be faster to define a User Setting, that calculates this value from Table A, and then each security filter just uses that User Setting. That way it would not be recalculating the value from Table A, every time?

[LeventK]

Is that TableA value a user-specific value? I mean might the value be changing from user to user?

[Steve]

Reevaluating a complex expression for every row can have an impact on sync times, yes, but security filters are evaluated on the server side, which are vastly more performant than mobile devices. Will it speed up sync? Maybe.

You could consider attaching a virtual column to table A that pre-computes the expression, and reference that in the security filter.