Performance issues in the web ui accessing repo related pages
Cloned from https://bugzilla.redhat.com/show_bug.cgi?id=1255005
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):
Steps to Reproduce:
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.