Hi! I'm building a property search feature and I'd like users to be able to exclude properties that they have previously marked as "favorite". There will be around 10M properties in the catalog and I'm estimating users to have on average ~200,000 properties marked as favorite. Is the negation filter (e.g.

id != [id1, id2, ...]

) the correct approach for this?

I'm estimating users to have on average ~200,000 properties marked as favorite.

200K across all users?

200K per user. Search endpoint may see QPS of 2-3k

Having 200K IDs in the negation filter will be too slow. I think it's better to look into joins.

Thanks Kishore, I'll look into that