I'm currently using ElasticSearch and storing all the data in one index for all my users.
The data sent by each user is by nature different for each user which makes my index fields number growing rapidly and exceeding 2000 fields. I'm thinking about switching to a multi-tenant approach where each user will have its own index but I'm not sure about what drawbacks can I face once having 10k indexes and if in the future it reaches 100k indexes.
Does elastic search support such a large number of indexes? Is the multi-tenant approach better than the single index even if it can reach 100k indexes?