High Users/Groups/Permissions scale causes slower UI experience and higher CPU utilization

Symptoms: Attempting to load many UI page in Artifactory takes longer than 30 seconds, and timeouts can be observed as well as high CPU utilization.

Steps to reproduce: 

• Artifactory 6.x (6.5.9 and 6.8.9 were used) Standalone/HA
• External (Oracle/MySQL) database

1. Create at least 25,000 Artifactory users
2. Create at least 125,000 Artifactory groups
3. Create around 30000 permission targets
4. Create around 4000 repositories with the above permissions taking affect for them
5. Attempt to navigate across the UI pages e.g. --> Build Browser, the Admin -> Security -> Permissions/users/groups page, observe slow loading and high CPU

• This can also occur at a medium level of permissions, around 900.