Project

General

Profile

Actions

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
Category:
Web UI
Target version:
Difficulty:
easy
Triaged:
Yes
Fixed in Releases:
Found in Releases:

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

Also available in: Atom PDF