Pagination and limit max number of pages

Elastic Stack Elasticsearch
1

We want to filter products, by search term, category, price, location, and a few more.

In Elasticsearch deep paging is problematic, but if we limit to 20 items per page and max number of pages to 100, will be this ok?

https://www.elastic.co/guide/en/elasticsearch/guide/current/pagination.html

2

Yes.

3

Thanks.

So query will still be performant/effective?

4

Yes. The lower from+size is the faster the execution is though.
Also doing that on one shard vs 100 shards also matters.

But I'd say: give it a try and you will see that with actual data and real queries.