Project

General

Profile

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'
Actions
Copy link

Also available in: Atom PDF