Bug #6389: Content hosts list is exceedingly slow - Katello - Foreman

Actions

Copy link

Bug #6389

closed

Content hosts list is exceedingly slow

Added by Partha Aji over 10 years ago. Updated over 6 years ago.

Status:

Closed

Priority:

Normal

Assignee:

Justin Sherrill

Category:

Web UI

Target version:

Katello 2.0

Difficulty:

easy

Triaged:

Yes

Bugzilla link:

1113170

Pull request:

Fixed in Releases:

Found in Releases:

Red Hat JIRA:

Description

Cloned from https://bugzilla.redhat.com/show_bug.cgi?id=1113170
Rendering a list of Content Hosts (approximately 10 registered hosts) takes 2-3 minutes.

If you turn on SQL debug you see pages and pages of:

CACHE (0.0ms)  SELECT COUNT() FROM "katello_repositories" WHERE "katello_repositories"."product_id" = 56 AND "katello_repositories"."content_id" = '2112'
  CACHE (0.0ms)  SELECT COUNT() FROM "katello_repositories" WHERE "katello_repositories"."product_id" = 56 AND "katello_repositories"."content_id" = '2113'
  CACHE (0.0ms)  SELECT COUNT() FROM "katello_repositories" WHERE "katello_repositories"."product_id" = 56 AND "katello_repositories"."content_id" = '1625'
  CACHE (0.0ms)  SELECT COUNT() FROM "katello_repositories" WHERE "katello_repositories"."product_id" = 56 AND "katello_repositories"."content_id" = '1922'
  CACHE (0.0ms)  SELECT COUNT() FROM "katello_repositories" WHERE "katello_repositories"."product_id" = 56 AND "katello_repositories"."content_id" = '2816'
  CACHE (0.0ms)  SELECT COUNT() FROM "katello_repositories" WHERE "katello_repositories"."product_id" = 56 AND "katello_repositories"."content_id" = '2815'
  CACHE (0.0ms)  SELECT COUNT() FROM "katello_repositories" WHERE "katello_repositories"."product_id" = 56 AND "katello_repositories"."content_id" = '1923'
  CACHE (0.0ms)  SELECT COUNT() FROM "katello_repositories" WHERE "katello_repositories"."product_id" = 56 AND "katello_repositories"."content_id" = '2114'
  CACHE (0.0ms)  SELECT COUNT() FROM "katello_repositories" WHERE "katello_repositories"."product_id" = 56 AND "katello_repositories"."content_id" = '1921'
  CACHE (0.0ms)  SELECT COUNT() FROM "katello_repositories" WHERE "katello_repositories"."product_id" = 57 AND "katello_repositories"."content_id" = '1871'