# Scroll Infinite in datatable
**URL:** https://discuss.elastic.co/t/scroll-infinite-in-datatable/2135
**Category:** Elasticsearch
**Created:** [June 8, 2015, 1:32pm UTC](https://discuss.elastic.co/t/scroll-infinite-in-datatable/2135 "2015-06-08T13:32:03Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@Marian\_Valero](https://discuss.elastic.co/u/Marian_Valero)
#### Post date: [June 8, 2015, 1:32pm UTC](https://discuss.elastic.co/t/scroll-infinite-in-datatable/2135/1 "2015-06-08T13:32:03Z")
Hi, I'm doing a search with scroll in java and I add this results, size = 20, in a datatable but I want do that dynamically, that is to say when I do scrolling to datatable add the next 20 results to datatable. How can I do that?
Thanks.
---
### Author:  [@Jason\_Wee](https://discuss.elastic.co/u/Jason_Wee)
#### Post date: [June 9, 2015, 12:59pm UTC](https://discuss.elastic.co/t/scroll-infinite-in-datatable/2135/2 "2015-06-09T12:59:27Z")
there you go [https://www.elastic.co/guide/en/elasticsearch/client/java-api/current/search.html#scrolling](https://www.elastic.co/guide/en/elasticsearch/client/java-api/current/search.html#scrolling) 😄
---
### Author:  [@nik9000](https://discuss.elastic.co/u/nik9000)
#### Post date: [June 9, 2015, 1:15pm UTC](https://discuss.elastic.co/t/scroll-infinite-in-datatable/2135/3 "2015-06-09T13:15:47Z")
> [@Jason\_Wee](#):
>
> there you go [Search API | Java Transport Client (deprecated) [7.17] | Elastic](https://www.elastic.co/guide/en/elasticsearch/client/java-api/current/search.html#scrolling)
Scroll uses server side resources so its not safe to expose to the internet. Probably not safe to expose to an intranet for infinite scroll either.
---
### Author:  [@Jason\_Wee](https://discuss.elastic.co/u/Jason_Wee)
#### Post date: [June 9, 2015, 1:51pm UTC](https://discuss.elastic.co/t/scroll-infinite-in-datatable/2135/4 "2015-06-09T13:51:10Z")
> [@nik9000](#):
>
> Scroll uses server side resources so its not safe to expose to the internet. Probably not safe to expose to an intranet for infinite scroll either.
eh? how would you do it then?
---
### Author:  [@nik9000](https://discuss.elastic.co/u/nik9000)
#### Post date: [June 9, 2015, 2:19pm UTC](https://discuss.elastic.co/t/scroll-infinite-in-datatable/2135/5 "2015-06-09T14:19:13Z")
> [@Jason\_Wee](#):
>
> eh? how would you do it then?
From and size with a limit on the depth is the only way to do it where you don't use server side resources between requests. Its not great either because you have to limit from + size because that is the number of results that have to be sorted.
---
### Author:  [@nik9000](https://discuss.elastic.co/u/nik9000)
#### Post date: [June 9, 2015, 2:25pm UTC](https://discuss.elastic.co/t/scroll-infinite-in-datatable/2135/6 "2015-06-09T14:25:33Z")
> [@nik9000](#):
>
> From and size with a limit on the depth is the only way to do it where you don't use server side resources between requests.
You could also use a filter and a sort - which is the traditional way to do it in relational databases and probably better than from/size now that I think about it.
The big issue with scroll is that it tries to give the user a consistent view of the data. Its super useful for something but its costly.
---
### Author:  [@Jason\_Wee](https://discuss.elastic.co/u/Jason_Wee)
#### Post date: [June 11, 2015, 11:03am UTC](https://discuss.elastic.co/t/scroll-infinite-in-datatable/2135/7 "2015-06-11T11:03:27Z")
sounds to me either ways, scroll in distributed cluster is expensive.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 6, 2017, 12:08am UTC](https://discuss.elastic.co/t/scroll-infinite-in-datatable/2135/8 "2017-07-06T00:08:13Z")