Paginginfo

Is there any more info available on how Paginginfo works within Appian ?

I've an upcoming use case where we will have a source of truth table which over time will become quite large. We will be doing all the user tricks to keep it responsive but at some point we will be querying it and no matter how many filters etc we get returned the data subset will be for a large amount of records. (let pretend 10,000).

i'll use pagingInfo to control the grid, but whilst I'm displaying records 1 to 100, what is happening to the rest of the data set ? I'm assuming it's floating around in Appian memory somewhere. 

I'm interested in people's thoughts here ?

  Discussion posts and replies are publicly visible

Parents
  • Depends on how you are querying - using load() or with(). As mentioned in one of the comment with() will trigger a fresh query each time you navigate. Have you tried making your batch size as dynamic for such large data being fetched. Assuming you are using a stored procedure as well - gives you more flexibility in controlling what you want
Reply
  • Depends on how you are querying - using load() or with(). As mentioned in one of the comment with() will trigger a fresh query each time you navigate. Have you tried making your batch size as dynamic for such large data being fetched. Assuming you are using a stored procedure as well - gives you more flexibility in controlling what you want
Children
No Data