When I tried to get data using a query filter for a custom picker and when I tried using record picker, I could find a significant performance difference. Record Picker was very fast when compared to a custom picker. How does record picker work and can we do the same for a custom picker also? And I would also like to know how record type actually holds the data, is it like a cached memory or it fetches every time? Can someone help me understand this?
Discussion posts and replies are publicly visible
https://docs.appian.com/suite/help/22.2/records-data-sync.html
This should give you a good start.
Can you post the code for your slow custom picker?
I used the same code from Appian documentation