# How to exclude users from search properly

**URL:** <https://discuss.elastic.co/t/how-to-exclude-users-from-search-properly/78092>\
**Category:** Elasticsearch\
**Created:** [March 10, 2017, 6:26am UTC](https://discuss.elastic.co/t/how-to-exclude-users-from-search-properly/78092 "2017-03-10T06:26:46Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![toka](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/toka/32/15773_2.png) [@toka](https://discuss.elastic.co/u/toka)\
**Post date:** [March 10, 2017, 6:26am UTC](https://discuss.elastic.co/t/how-to-exclude-users-from-search-properly/78092/1 "2017-03-10T06:26:46Z")

</div>

Hi all,

I need to exclude from search users that already interacted with each other. I solved it in the next way:

Just added an `exclude_ids` field to the user index. For example, let's say that when the user with id 1 is searching, we use a Term Query to check that id 1 is not inside exclude\_ids of target users, a query like:

```auto
{
  ...
    "must_not": { 
       "term": { "exclude_ids": 1 }
    }
 ...
}

```

After using it I found out that:

Search is fast

- Taking into account how the inverted index works I think this usage is correct
- Search is done inside the same index (having to search in other indexes means checking more shards)

Updates are slow

- Each time an id is added to exclude\_ids the whole document is reindexed, since partial updates to a document are not possible in ES. If the exclude\_ids array gets very long, the updates can become specially slow, becoming a bottleneck in the system.
- For the same reason, indexed data that is not usually updated is reindexed, like name or age.

Definitely this does not scale good. I thought of some solutions but I can not find an optimal one. I came up with these ideas:

- Using [Terms Filter Lookup](https://www.elastic.co/blog/terms-filter-lookup) could be an option, but I wonder about the performance with many terms (around 10000-50000 depending on the case).

- Not storing `exclude_ids` in Elasticsearch, but in another place; sending all the ids in a `Terms` or `Ids` query, but I'm worried about how that would impact the performance of the search itself.

- Using parent/child could be other way, but this would mean indexing many documents per user, plus the structure of the parent mapping and child mapping would be very different (a lot of disperse data).

Any ideas?  
Thank you very much.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [April 7, 2017, 6:26am UTC](https://discuss.elastic.co/t/how-to-exclude-users-from-search-properly/78092/2 "2017-04-07T06:26:55Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.