Uploaded image for project: 'EJBCA'
  1. EJBCA
  2. ECA-6899

Add case sensitive end entity search in WS for better performance

    Details

    • Type: New Feature
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Protocols
    • Labels:
      None
    • Issue discovered during:
      Customer

      Description

      The findUser function with the MATCH_WITH_USERNAME performs a case-insensitive search (with an 'UPPER(username) = "xx"' style query). This hurts performance.

      We should add a new match type MATCH_WITH_USERNAME_CASEINSENS to perform case-sensitive searches (i.e. a plain 'username = "xx"' query).

      WS documentation (javadoc) should also be updated to mention the performance difference of MATCH_WITH_USERNAME and MATCH_WITH_USERNAME_CASEINSENS

        Attachments

          Activity

            People

            Assignee:
            samuel Samuel Lidén Borell
            Reporter:
            samuel Samuel Lidén Borell
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated: