Description of problem: In satellite 6.1.1 we experience very noticable slowdown in the responsiveness of the web ui at various points in the web ui. It seems to be primarily related to the katello bits and within that it seems to be whenever repositories are involved in the query. Version-Release number of selected component (if applicable): How reproducible: Steps to Reproduce: 1. 2. 3. Actual results: Expected results: Additional info: A user interface must be responsive. Tasks take time is ok. That is why there is a task engine. Tasks like repo sync, publish, promote take time. However building up a web page should be as snappy as in satellite 5. Examples are rendering the products page, rendering the repository page of a product when there are around 10 repositories, building up the list of content hosts. If you look at the information that is on the page and must be retrieved from the database, the query that must retrieve that data takes up way to much time.
Created redmine issue http://projects.theforeman.org/issues/11561 from this bug
Upstream bug component is WebUI
This is likely a dupe of https://bugzilla.redhat.com/show_bug.cgi?id=1253802 which is scheduled to go out in the next 6.1.z errata. The number one source of the performance issue was viewing repositories when their product was associated to a sync plan. So an easy way to know if 1253802's fix will resolve your issue is if you remove the products from their sync plan and you see performance improve quite a bit. I saw we wait until that errata goes out and if this is still present we investigate again, ideally with user data
re-assigning to Adam who is working performance stuff for 6.2
Some areas this bug mentions have already been addressed, but I believe all portions will be addressed once https://bugzilla.redhat.com/show_bug.cgi?id=1265884 is merged. Marking this bug as a duplicate of that BZ, since that is the last remaining area of this BZ that needs attention. *** This bug has been marked as a duplicate of bug 1265884 ***