How to improve the speed of a limit N rows table collab filter?

[Ed_Wei]

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
      )
  )

[Shaina_Torgerson]

Hey @Ed_Wei ! Sorry to hear that your filter formula is slowing down the performance of your doc. I would first recommend checking out some of these help articles we’ve created on improving doc performance:

• Optimizing slow formulas in your doc

• Improving performance

• And others here

If the information there doesn’t help, please do let us know and we’d be happy to take a closer look. Having an example doc displaying the issues is always the best way for us to help you troubleshoot! You share with us by going to the Share in the top right hand corner, clicking the button in the top right (to the left of the “X”), and toggling on Share with Coda Support. Afterwards, please send us a link to that doc in your response so we can take a look.

Hope this helps!