Read-only Grid Paging Algorithm

Question

Hello everyone, 
 I want to understand how a grid field works when using a sync-enabled record as the data source. 
 Let&rsquo;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&rsquo;s cache memory to display the data?

Goddati Venkatesh · Answer

Thank you for your time and response, Harsha Sharma It is clear now.

VarunTejaGurrapu · Answer

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.

Harsha Sharma · Answer

During record sync the data will be queried from database and stored in Appian record type. This is like a virtual data layer when data is kept for optimised data storage and retrieval within Appian's data architecture. 
 In a grid when you page, the first batch shows first 10 rows of that record type, on click of next, the next 10 are retrieved from record type and shown. 
 Goddati Venkatesh said: will it use Appian’s cache memory to display the data? 
 You are thinking in correct direction here. No database transaction happens when grid page is modified rather user is working with Appian data fabric layer to see the next batch of data which is the optimised way to working with data in Appian. Hope it clarifies

Shubham Aware · Answer

When you click Next on a sync-enabled record-backed grid, Record grid makes a database query to its synced database (Appian Data Server) to fetch the next 10 rows. No call is made to your source on pagination. https://docs.appian.com/suite/help/26.5/about-data-sync.html#optimized-data-access

Read-only Grid Paging Algorithm

Top Replies