CODEWITHSUNDEEP
azure-cognitive-search
doorman
doorman

Reputation: 16949

Filter by array of ids

I am planning to implement a search filter by array of ids. This array could have up to 1000 - 10000 ids. Is the recommended way to filter based on id´s like this?

$filter=Id eq 'ID1' or Id eq 'ID2'

Is this expensive performance vice? Is this expensive price vice?

Upvotes: 1

Views: 940

Answers (1)

Bruce Johnston
Bruce Johnston

Reputation: 8634

Currently it is not possible to filter by that many IDs in a single query due to Azure Search's filter size limits. If you were filtering by a few hundred IDs it would be possible, but thousands is definitely not going to work.

We are considering ways to relax the limit or provide alternative mechanisms, but nothing will change in the near future.

Upvotes: 1

Related Questions