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

Repository list is slow when there are lots of artifacts on root of a repository

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: 6.13.0
    • Component/s: None
    • Labels:
    • Severity:
      High

      Description

      When Artifactory loads the repository list (UI home page or tree browser), if there are lots of artifacts available on root level of repository, the UI will take a long time to load.

      Steps to reproduce:
      1. Upload 2 million artifacts to the root folder of any repository.
      2. Open the home page / tree browser, see the slowness.

      Root cause for slowness is that for the repository list we issue this query for all repositories.
      Against a repository with ~2 million files on root level, it takes approx. 30 seconds to run.

      SELECT COUNT(1) FROM nodes WHERE repo = 'REPO-NAME' AND node_path = '.' AND depth = 1
      

      Imagine having lots of such repositories, the performance gets worse.

      As a precaution, you can try to avoid uploading files to the root of repositories.

        Attachments

          Issue Links

            Activity

                People

                Assignee:
                omriz Omri Ziv
                Reporter:
                arielk Ariel Kabov
                Votes:
                3 Vote for this issue
                Watchers:
                7 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    Sync Status

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