Bug #15233: viewing CV version list slow as packages are added - Katello - Foreman

Actions

Copy link

Bug #15233

closed

viewing CV version list slow as packages are added

Added by Chris Duryee over 8 years ago. Updated about 6 years ago.

Status:

Closed

Priority:

Normal

Assignee:

Chris Duryee

Category:

Content Views

Target version:

Katello 3.0.0

Difficulty:

Triaged:

Bugzilla link:

1265884

Pull request:

https://github.com/Katello/katello/pull/6086

Fixed in Releases:

Found in Releases:

Red Hat JIRA:

Description

As the `katello_repository_rpms` table grows, the CVV page gets slower and slower. For example, this query can take 300+ msec:

LOG:  duration: 329.058 ms  execute a36: SELECT COUNT(*) FROM "katello_rpms" INNER JOIN "katello_repository_rpms" ON "katello_repository_rpms"."rpm_id" = "katello_rpms"."id" WHERE "katello_repository_rpms"."repository_id" IN (SELECT "katello_repositories"."id" FROM "katello_repositories"  WHERE "katello_repositories"."content_view_version_id" = $1 AND (environment_id is NULL))

This is run once for every CVV on the page.