I have indexed all Users (10 million records) and I plan to index a Table that store visits of a user to another user.
I wish to show to the User 100 users they have never visited.
For some users I have to exclude up to 80'000 already visited users.
How should I Index the visits? As 1 doc for one visit or all visits from a user in 1 doc?
And how should I query the proposed users?
I have seen there is now the join datatype but I'm not sure uf this is the right way and how to use it.
I'm using ES 6.4.