Alternative to grid with more than 10000 of data

Hi All,

I have this scenario that I have to populate a grid with more than 10000 of rows. As we know, doing this is not a best practice. Can anyone suggest any alternative to this in a report that how can we display that data?

  Discussion posts and replies are publicly visible

Parents Reply
  • +1
    Appian Employee
    in reply to Varun
    Depending on the source of the data, query latency is a consideration in your use case: How long is it going to take to for appian to retrieve this data? Is it coming from database? If so, is this a table or a view? Are the indexes good?
    What about if the data is retrieved from an integration. How long does it take to transmit the data over a web service? Does the service employ batch size and paging conventions?

    If you're planning a database query, you might want to use an explicit user initiated search before running the query.
    Also, you can include filter criteria to limit the result set down to something useful. (Again, no one is going to read 10,000 rows of data in a brief instant.)
    These docs show how to create a filtered query.
    docs.appian.com/.../Query_Recipes.html

    Similar to the pagingInfo convention used in Appian queries. You can use paging info in your grid configuration to control how many rows to display to a user at once:
    docs.appian.com/.../Paging_Grid_Component.html

    Is this helpful?
Children