Created attachment 1065260 [details] production.log with rails debug on, grep over UI worker PID Description of problem: In a large scale environment navigating to Configure->Configuration and then selecting "Access Control" on the left side accordion and navigating to different groups requires a large amount of time and creates a tremendous number of queries (>10k). For instance selecting EvmGroup-administrator results in a render time of ~50s in this large scale environment. This large scale environment consists of an inventory of 100k VMs. The user is presented with a spinner while the rendering is occurring. Version-Release number of selected component (if applicable): 5.4 How reproducible: Always with this environment Steps to Reproduce: 1. 2. 3. Actual results: [----] I, [2015-08-20T12:35:36.786465 #6425:d4de9c] INFO -- : Completed 200 OK in 50732.7ms (Views: 159.4ms | ActiveRecord: 13482.5ms) Expected results: ~5s or less to render a page/ Additional info: $ grep -i "SELECT" production.log -c 13314 $ grep -i "CACHE" production.log -c 6037
Oleg merged for 5.6.1 release,..setting to Post. SHA 2a80df04407bae618c779077581a49d8e982630d
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://rhn.redhat.com/errata/RHSA-2016-1634.html