# How to pagination many data?(data count example 100,000)

**URL:** <https://discuss.elastic.co/t/how-to-pagination-many-data-data-count-example-100-000/295205>\
**Category:** Elasticsearch\
**Created:** [January 24, 2022, 9:17am UTC](https://discuss.elastic.co/t/how-to-pagination-many-data-data-count-example-100-000/295205 "2022-01-24T09:17:09Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![sramana235](https://avatars.discourse-cdn.com/v4/letter/s/bbce88/32.png) [@sramana235](https://discuss.elastic.co/u/sramana235)\
**Post date:** [January 24, 2022, 9:17am UTC](https://discuss.elastic.co/t/how-to-pagination-many-data-data-count-example-100-000/295205/1 "2022-01-24T09:17:09Z")

</div>

I want to display more than 100,000 data on a 1page 10data.  
For example, when i press page 1023, Data from 10221 to 10230 should be displayed.  
In this case, should I use 'search after' instead of 'scroll'?  
If it is being developed by C++ and needs to use 'search after', I wonder if it is possible to find the '\_pit id' and then create a formula to operate 'search after' several times to obtain the desired value.

I ask for your help.

---

<div class="post-metadata">

**Author:** ![mayya](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mayya/32/83147_2.png) [@mayya](https://discuss.elastic.co/u/mayya)\
**Post date:** [January 27, 2022, 9:59pm UTC](https://discuss.elastic.co/t/how-to-pagination-many-data-data-count-example-100-000/295205/2 "2022-01-27T21:59:24Z")

</div>

Yes, a recommend way to paginate through data would be to use `_pit` with `search_after`

---

<div class="post-metadata">

**Author:** ![sramana235](https://avatars.discourse-cdn.com/v4/letter/s/bbce88/32.png) [@sramana235](https://discuss.elastic.co/u/sramana235)\
**Post date:** [February 3, 2022, 5:58am UTC](https://discuss.elastic.co/t/how-to-pagination-many-data-data-count-example-100-000/295205/3 "2022-02-03T05:58:08Z")

</div>

thank you 🙂  
I will refer to it and solve it well.

---

<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:** [March 3, 2022, 5:58am UTC](https://discuss.elastic.co/t/how-to-pagination-many-data-data-count-example-100-000/295205/4 "2022-03-03T05:58:37Z")

</div>

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