I am currently working on indexing searchable items from MS SQL to Elasticsearch. Currently there are over 20 million records which needs to be pushed to ES which constitutes to 20 millions documents in ES index.
The record count will keep increasing and we have a projection rate of 7 Million documents / year. The query is that, how many documents can a single index hold and is there a hard limit imposed by ES to limit document count.
Please clarify the query.