Rich DataScroller hitting database for every pagination requ

[anand_sridhar]

Hi,
I see that the datascroller component I use goes to database to retrieve the whole results for every page navigation I do.

For example, if the total no of results are 1000, and each page shows 10 of them, paginating from page 1 to 2 makes another call to database to fetch all 1000 again.

Is this the normal behavior of Rich Datascroller Component.?
Is there any mechanism Rich Faces provides to cache the result set initially and do the scroll on that in memory result set. ?

[nbelaevski]

Hello,

Datascroller doesn't fetch all rows, it just does one query for rows count. Take a look at livedemo examples for an example of in-memory result set.

[anand_sridhar]

Could you send me the link for the example you are talking about. ?
I used this link
http://livedemo.exadel.com/richfaces-demo/richfaces/dataTableScroller.jsf?c=dataTableScroller&tab=info, but it does not talk about the original issue.

[nbelaevski]

Sure, it's here: http://livedemo.exadel.com/richfaces-demo/richfaces/dataTable.jsf?tab=dataModel&cid=3638276