Why is the permissions screen slow to load

JFrog Support
2018-11-13 23:24


Artifactory permissions UI and API can be slow when loading a large amount of permission targets

Affected Versions

5.8.9 to 6.0


This is caused by by a change in Access queries that joins a non-indexed column.  This can cause slowness as permission targets approach 20k permission targets


The Issue is fixed in 6.1.0
If an upgrade is not immediately feasible, the issue can be mitigated by adding the following index to the table ACCESS_PERMISSION_ACTION on the table perm_ID:

articapital=# CREATE INDEX access_perm_action_perm_id_idx ON access_permission_action (perm_id);