Appian Community and Appian Academy are being upgraded. As a part of the upgrade, Appian Community is currently in read-only mode, and user registration is disabled until August 3. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!

The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.

Read-only Grid Paging Algorithm

Certified Senior Developer

Hello everyone,

I want to understand how a grid field works when using a sync-enabled record as the data source.

Let’s say I have 100 records.

If I display 10 records per page, there will be 10 pages in total. Now, when I click on the Next icon in pagination, will the grid make a separate call to the database to fetch the next set of 10 records, or will it use Appian’s cache memory to display the data?

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Senior Developer

    When a user clicks Next in a grid backed by a sync-enabled Record Type, Appian sends a new query with updated paging information (startIndex and batchSize). The data is retrieved from the Appian Data Server, which stores the synchronized record data. Appian does not load all records into browser memory; instead, each page request retrieves only the required subset of records from Data Server, making pagination efficient and scalable.

Reply
  • 0
    Certified Senior Developer

    When a user clicks Next in a grid backed by a sync-enabled Record Type, Appian sends a new query with updated paging information (startIndex and batchSize). The data is retrieved from the Appian Data Server, which stores the synchronized record data. Appian does not load all records into browser memory; instead, each page request retrieves only the required subset of records from Data Server, making pagination efficient and scalable.

Children