I'm using a record type in my grid column and need to keep a few columns as sort fields.
I was curious as to whether the sortField columns impact the performance of the record type?
Discussion posts and replies are publicly visible
Hi priyaroy
Yes, it can impact the record type performance in Appian. When you sort a record type's data, Appian needs to retrieve and sort all the relevant records before displaying them to the user. Especially if the record type has a large amount of data or complex sorting requirements.
Limit the number of records returned: If possible, use pagination or filters to limit the number.
Here we are talking about sortField configured in grid column inside gridField() and not while querying the record type. It would have little or no impact on the record type performance.