I have a query form with table in a page and I'm trying to use paging instead of using scroll to see all the data returned by the query.
I have found a link that explains how can I do it site1 and it works, but when I try to access one page ahead, for example page 400 or 1000 it takes too long to return that data.
I also have found another one site2 that explains that I have to change som properties in the VO of that data. I have tryed to use both simultaneous, only the second one but with no success.
Is there a way to do it that does not take too long to fetch the data?
I was able to put pagination to work, changing this
In the VO Sector Tunning All Rows; In Batches of: 100
Component Table Appearance / ScrollPolicy - page Behaviour / AutoHeightRows - 0 Style / StyleClass - AFStretchWidth