Response is terribly slow, when using from/size for pagination for large 'from' values


#1

The corresponding query nearly returns 3 million documents.

From : 1, size : 50 => Response comes within 2 seconds.
From : 1,000,000, size : 50 => Response comes after 20 seconds.

If we send multiple concurrent requests for the second instance, Elasticsearch instance hangs up. What are the possible approaches we can take in this scenario?

Thanks


(Mark Harwood) #2

First paragraph of this doc is relevant: https://www.elastic.co/guide/en/elasticsearch/reference/current/search-request-search-after.html


(system) #3

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