Uploaded image for project: 'Grouper'
  1. Grouper
  2. GRP-4428

For SQL subject source, add option for search column to wildcard just the suffix

    XMLWordPrintable

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.

      Attachments

        Activity

          People

            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            chad.redman.3@at.internet2.edu Chad Redman
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: