Uploaded image for project: 'Artifactory Binary Repository'
  1. Artifactory Binary Repository
  2. RTFACT-14559

GAVC search takes too long to respond when you leave Group ID empty or provide a wildcard

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Normal
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Search, Web UI
    • Labels:

      Description

      GAVC search in UI takes too long to respond when you leave Group ID empty or provide a wildcard.

      When this field is left empty or just a wildcard is provided, the SQL query also uses a wildcard for the LIKE operator in the search query. When using only the wildcard for LIKE operator SQL does not use the indexes in the table and the search takes too long to respond.

      We need to add a message in the UI when GAVC search is used. Something like this "Please do not leave the Group ID field empty and also don't provide only a wildcard, as this will cause the search to be slow"

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              nihalc@jfrog.com Nihal Reddy Chinna Choudhary
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: