I would like to improve the performance of ~200 rows each with about 100 columns.
I’ve attempted to create a table filter which enables me to filter the rows first by a text search and then by a limit in the number of results. This order of search first is important to me because I want the search to function find the entry even if it is not in the last N results.
However, this filter is slow “Table collab filter” now shows up as as a slow step when measuring the performance.
What my filter looks like:
thisRow .In( thisTable .filter( (IsBlank([Portfolio Pre Filter]) or ContainsText( CurrentValue.Address, [Portfolio Pre Filter], ignoreCase: True(), ignoreAccents: True() )) ) .Sort( False(), thisTable.Updated ) .Slice( 0, 20 ) )