Hello Elastic experts,
I have a simple index with 100M books and each book has an unique book ID (string). I have another 1M book IDs (the 1M book ID belongs to 100M book IDs), and my query is simple, I just want to retrieve the 1M books information stored in Elastic Search cluster by book IDs (kinds of filter the 100M books by the 1M book IDs).
My current concern is if I pass the 1M book ID in a single query, the query will be super huge JSON, will there be any problems? But to send 1M queries with each query a single book ID may be too much overhead of the # of queries? Any good solutions is appreciated.
thanks in advance,