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
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
Thank you for your time and response,Harsha Sharma It is clear now.