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.
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.