• Replies 6 replies
  • Subscribers 12 subscribers
  • Views 10462 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Best Practices

Paginginfo

pauls0003
A Score Level 1

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
  • A Score Level 1
    Hi,
    It really depends whether you are querying the truth table inside a load() or with()
    if you query it inside a load() with negative batchsize and then use the data in the paging grid with a separate pagingInfo having smaller batchsize (say 20) then all the data will be available in the queried datasubset however if you query it inside a with(), everytime you navigate to the next/previous page a fresh query gets fired and fetches the result as per the start index and batch size.
    I hope this information helps.
    Thanks
Reply
  • A Score Level 1
    Hi,
    It really depends whether you are querying the truth table inside a load() or with()
    if you query it inside a load() with negative batchsize and then use the data in the paging grid with a separate pagingInfo having smaller batchsize (say 20) then all the data will be available in the queried datasubset however if you query it inside a with(), everytime you navigate to the next/previous page a fresh query gets fired and fetches the result as per the start index and batch size.
    I hope this information helps.
    Thanks
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.