Performance Issues in pickerFieldRecords

If you truly want to leverage a synced record type, one valid approach is to define a Web Service (Integration) as the data source instead of querying the database view directly. This allows you to take full advantage of the capabilities provided by synced records, such as:

• Improved performance through Appian’s in-memory caching for synced data.

• Full support for pickerFieldRecords with optimized search and filtering behavior.

• Ability to control data synchronization frequency, including on-demand syncs via a related action or process.

To implement this:

• Create an Integration object that calls a web service (which returns the view data).

• Use that Integration as the source of a Synced Record Type.

• Map and configure fields accordingly for use in your record picker or interfaces.

This way, you avoid the performance pitfalls of live queries against complex database views and gain the full benefits of Appian’s data sync architecture.

If you truly want to leverage a synced record type, one valid approach is to define a Web Service (Integration) as the data source instead of querying the database view directly. This allows you to take full advantage of the capabilities provided by synced records, such as:

• Improved performance through Appian’s in-memory caching for synced data.

• Full support for pickerFieldRecords with optimized search and filtering behavior.

• Ability to control data synchronization frequency, including on-demand syncs via a related action or process.

To implement this:

• Create an Integration object that calls a web service (which returns the view data).

• Use that Integration as the source of a Synced Record Type.

• Map and configure fields accordingly for use in your record picker or interfaces.

This way, you avoid the performance pitfalls of live queries against complex database views and gain the full benefits of Appian’s data sync architecture.

Thanks Alberto Cortés  for your prompt response. I like this idea to create  web service and leverage all the Record features. 

Just to mention one important consideration:
When using a synced record type backed by a web service (Integration), the data you get in Appian is not real-time. You only have access to the last synchronized version of the data, which means any updates in the source system won't be reflected in Appian until the next sync occurs (either scheduled or triggered manually).

If real-time data is a strict requirement for your use case, then this approach might not be ideal unless you're able to control the sync frequency or trigger a sync as part of your process.