Result window is too large Error

Elastic Stack Elasticsearch
1

Hello,
I am getting an error message when doing paged search from kendo data grid on elasticsearch:
"Result window is too large, from + size must be less than or equal to: [10000] but was [44800]..."

The index has approx 45,000 docs and page size is set to 100 so there are 448 pages.
I am not reading all records from elasticsearch, instead using paging.
This error occurs when i read last page. Why do I have this error and how to resolve the problem?
Thank you

2

Hi @skv325

Check this topic there's already a reply about your error and how to solve it.

And here the documentation about pagination if you want to read more about:

There's more explanation on stackoverflow and on this forum if you search about your error:

3

You can use:

  • the size and from parameters to display by default up to 10000 records to your users. If you want to change this limit, you can change index.max_result_window setting but be aware of the consequences (ie memory).
  • the search after feature to do deep pagination.
  • the Scroll API if you want to extract a resultset to be consumed by another tool later.
4

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