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

    XMLWordPrintable

    Details

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

      Description

      Edit:
      Package search - Maven GAVC in UI without GroupId has a really bad performance. A search request, if you don’t know the GroupId (a common use case) lasts about 2 minutes. The same search via API lasts 8 seconds.

      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:
            2 Start watching this issue

              Dates

              Created:
              Updated:

                Sync Status

                Connection: RTFACT Sync
                RTMID-14559 -
                SYNCHRONIZED
                • Last Sync Date: