# Deep pagination and multiple shards

**URL:** <https://discuss.elastic.co/t/deep-pagination-and-multiple-shards/21926>\
**Category:** Elasticsearch\
**Created:** [January 30, 2015, 5:02pm UTC](https://discuss.elastic.co/t/deep-pagination-and-multiple-shards/21926 "2015-01-30T17:02:14Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Herve\_Eichwald](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/herve_eichwald/32/947_2.png) [@Herve\_Eichwald](https://discuss.elastic.co/u/Herve_Eichwald)\
**Post date:** [January 30, 2015, 5:02pm UTC](https://discuss.elastic.co/t/deep-pagination-and-multiple-shards/21926/1 "2015-01-30T17:02:14Z")

</div>

Hello guys,

reading this  
doc: [http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/search-request-scroll.html#scroll-scan](http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/search-request-scroll.html#scroll-scan)  
I do not understand the following:  
Deep pagination with from and size  
[http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/search-request-from-size.html](http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/search-request-from-size.html)  
— e.g. ?size=10&from=10000 — is very inefficient as (in this example)  
100,000 sorted results have to be retrieved from each shard and resorted in  
order to return just 10 results. This process has to be repeated for every  
page requested.

why is it 100,000 and not 10010?

Thanks

--  
You received this message because you are subscribed to the Google Groups "elasticsearch" group.  
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/f17e0821-bc69-4fb8-8288-79287a16bff0%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/f17e0821-bc69-4fb8-8288-79287a16bff0%40googlegroups.com).  
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 12:35am UTC](https://discuss.elastic.co/t/deep-pagination-and-multiple-shards/21926/2 "2017-07-06T00:35:36Z")

</div>