Details
-
Improvement
-
Resolution: Unresolved
-
Minor
-
None
-
2.5.40, 2.6.0
-
None
-
None
Description
For new style SQL subject sources (GrouperJdbcSourceAdapter2_5), parameter lowerSearchCol is a wildcard search, appending '%' both before and after the search string. The wildcard prefix negates the effect of any indexes on the field, and it needs to do a full table scan to find substring matches. If there were an option to only add the '%' to the suffix of the string and not the prefix, it may perform better when the subject table is large.