# Different result ordering with regard to 10000 limitation

**URL:** <https://discuss.elastic.co/t/different-result-ordering-with-regard-to-10000-limitation/355171>\
**Category:** Elasticsearch\
**Created:** [March 11, 2024, 3:44pm UTC](https://discuss.elastic.co/t/different-result-ordering-with-regard-to-10000-limitation/355171 "2024-03-11T15:44:39Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![sliu](https://avatars.discourse-cdn.com/v4/letter/s/a9a28c/32.png) [@sliu](https://discuss.elastic.co/u/sliu)\
**Post date:** [March 11, 2024, 3:44pm UTC](https://discuss.elastic.co/t/different-result-ordering-with-regard-to-10000-limitation/355171/1 "2024-03-11T15:44:39Z")

</div>

I have a search that has lot results, only "first" 10000 are accessible as commonly known. If I allow users change the ordering of search results (for instance, "order by column 1", "order by column 2", etc.), will user get different sets of 10000 results?  
In other words, does the ordering happen before OR after Elasticsearch making the cut of 10000 results?

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [March 11, 2024, 4:37pm UTC](https://discuss.elastic.co/t/different-result-ordering-with-regard-to-10000-limitation/355171/2 "2024-03-11T16:37:55Z")

</div>

> [@sliu](#):
>
> In other words, does the ordering happen before OR after Elasticsearch making the cut of 10000 results?

The sort is done before. And then only the requested size is sent to the client.

> [@sliu](#):
>
> If I allow users change the ordering of search results (for instance, "order by column 1", "order by column 2", etc.), will user get different sets of 10000 results?

Most likely yes.

---

<div class="post-metadata">

**Author:** ![sliu](https://avatars.discourse-cdn.com/v4/letter/s/a9a28c/32.png) [@sliu](https://discuss.elastic.co/u/sliu)\
**Post date:** [March 11, 2024, 6:18pm UTC](https://discuss.elastic.co/t/different-result-ordering-with-regard-to-10000-limitation/355171/3 "2024-03-11T18:18:46Z")

</div>

Thank you for the response.

---

<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:** [April 8, 2024, 6:19pm UTC](https://discuss.elastic.co/t/different-result-ordering-with-regard-to-10000-limitation/355171/4 "2024-04-08T18:19:27Z")

</div>

Closed on April 8, 2024, 6:19pm UTC

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