Project

General

Profile

Bug #11447

Fetching product or repo list using sync plans with large number of tasks takes minutes

Added by Justin Sherrill about 3 years ago. Updated 2 months ago.

Status:
Closed
Priority:
Normal
Category:
API
Target version:
Difficulty:
easy
Triaged:
Yes
Bugzilla link:
Team Backlog:
Fixed in Releases:
Found in Releases:

Description

Cloned from https://bugzilla.redhat.com/show_bug.cgi?id=1253802
Description of problem:

Customer has 5 products enabled with: 46, 5, 2, 2 & 2 repositories in each one. All 5 products are in the same sync plan. There are also 141916 tasks in the ForemanTask::Task table and 549906 locks in the lock table.

Loading the products page takes about 10 minutes. Loading the repositories page for a product takes ~5 minutes

Version-Release number of selected component (if applicable):
6.1.1

How reproducible:
Always

Steps to Reproduce:
1. Populate a satellite with the above stats
2. Visit the products list and the repo list for a product

Actual results:
takes minutes to load

Expected results:
Loads fairly quickly

Additional info:

Associated revisions

Revision c320d524 (diff)
Added by Justin Sherrill about 3 years ago

fixes #11447 - improve performance of product and repo index lists

alongside https://github.com/theforeman/foreman-tasks/pull/129 this has shown to improve
a particular users product page load from ~10 minutes down to ~4 seconds

Revision bbcea207
Added by Justin Sherrill about 3 years ago

Merge pull request #5435 from jlsherrill/11447

fixes #11447 - improve performance of product and repo index lists

History

#1 Updated by The Foreman Bot about 3 years ago

  • Status changed from New to Ready For Testing
  • Pull request https://github.com/Katello/katello/pull/5435 added
  • Pull request deleted ()

#2 Updated by Justin Sherrill about 3 years ago

  • Assignee set to Justin Sherrill
  • Legacy Backlogs Release (now unused) set to 77
  • Difficulty set to easy
  • Triaged changed from No to Yes

#3 Updated by Justin Sherrill about 3 years ago

  • Status changed from Ready For Testing to Closed
  • % Done changed from 0 to 100

Also available in: Atom PDF