Hello, Unless we're reading from a sorted index, it seems like elasticsearch will always read all matching rows into memory and then sort through them. Essentially, this makes it so the main advantage of using search_after over size/from is that using the latter, each node handling the query would…

On the advantage of search_after under the hood

Christian_Dahlqvist (Christian Dahlqvist) July 9, 2024, 7:15am 2

Please do not open multiple threads on the same issue.

No, this is not at all how it works.

Please see my response to your other thread for additional details.

Topic		Replies	Views
Search_after vs deep pagination Elasticsearch	5	13450	June 20, 2017
ES pagination under the hood Elasticsearch	2	334	May 19, 2023
Why is search_after preferred over Scroll API? Elasticsearch	2	1130	January 25, 2022
Recommendation to use search after instead of scrolling Elasticsearch	5	8422	April 22, 2021
Iterating through large datasets in various orders efficiently Elasticsearch	4	101	July 9, 2024