Resolving long delays in populating a drop down list with values in group criterion for selections takes long time in Portrait Dialogue.


Customer had to wait up to a minute to populate drop down list with 3 values.



This is more likely caused by the lookup source SQL query that returns too many records.
Lookup SQL query is defined in Define lookup section of a domain then used in a desired field name.

User-added image

Lookup functionality is designed with lookup sources in the range up to around 1000 records.
The issue was caused by the lookup source that had 85 000 records which stretched the functionality to its limit causing the long time of populating the drop down list.

User-added image


UPDATED: August 30, 2017
After customer decreased the number of records of lookup source to 1500 then populating the drop down list became much faster.