AnsweredAssumed Answered

Question about distinct (unique) values on Search Field - eSearch

Question asked by jeff.pace Champion on Jul 30, 2018
Latest reply on Jul 31, 2018 by rscheitlin


 We are struggling to use the eSearch Widget.  Would love to use it as it fits almost all our needs but one.


When we choose unique values on a field, instead of using the get distinct JSON API function, it is doing 10k's querys by groups of objectid.  With 230k records, this takes minutes for the widget to load and be ready


Using get distinct we can get the distinct list back in 0.5seconds. 


IS there any way to improve the performance?


I am at Portal 10.5.1 at the moment… 


Robert Scheitlin, GISP