# Efficient deep pagination, or equivalent of solr shards.rows

**URL:** <https://discuss.elastic.co/t/efficient-deep-pagination-or-equivalent-of-solr-shards-rows/135660>\
**Category:** Elasticsearch\
**Created:** [June 13, 2018, 9:14am UTC](https://discuss.elastic.co/t/efficient-deep-pagination-or-equivalent-of-solr-shards-rows/135660 "2018-06-13T09:14:14Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![poppemp](https://avatars.discourse-cdn.com/v4/letter/p/edb3f5/32.png) [@poppemp](https://discuss.elastic.co/u/poppemp)\
**Post date:** [June 13, 2018, 9:14am UTC](https://discuss.elastic.co/t/efficient-deep-pagination-or-equivalent-of-solr-shards-rows/135660/1 "2018-06-13T09:14:15Z")

</div>

Howdy!  
We have a public-facing search function where certain users routinely can navigate quite deeply in the result set and reach the max\_result\_window.

I found a very interesting article about solr where they limit the number of hits per shard for (very) deep pagination and thus I wonder if the tools exist to pull off the same thing in elasticsearch?

> **[Efficiently Handling Deep Pagination In A Distributed Search Engine](https://tech.shutterstock.com/2017/05/09/efficiently-handling-deep-pagination-in-a-distributed-search-engine/)**
>
> “Hey, you told me you had 10 million results. What’s the deal!” As users, we don’t always find what we’re looking for on the first page, so we click “next page&#…

---

<div class="post-metadata">

**Author:** ![poppemp](https://avatars.discourse-cdn.com/v4/letter/p/edb3f5/32.png) [@poppemp](https://discuss.elastic.co/u/poppemp)\
**Post date:** [June 15, 2018, 11:54am UTC](https://discuss.elastic.co/t/efficient-deep-pagination-or-equivalent-of-solr-shards-rows/135660/2 "2018-06-15T11:54:09Z")

</div>

After some research I found a few features that _almost_ does the right thing:

- terminate\_after - It has a different use case and doesn't do any shard-level sorting before terminating.
- shard\_size - It's only for aggregations

So, it would seem it's currently not possible.

---

<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 13, 2018, 11:54am UTC](https://discuss.elastic.co/t/efficient-deep-pagination-or-equivalent-of-solr-shards-rows/135660/3 "2018-07-13T11:54:17Z")

</div>

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