Bug #11447

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

Added by Justin Sherrill over 2 years ago. Updated over 2 years ago.

Status:Closed
Priority:Normal
Assigned To:Justin Sherrill
Category:API
Target version:-
Difficulty:easy Pull request:https://github.com/Katello/katello/pull/5435
Bugzilla link:1253802
Story points-
Velocity based estimate-
ReleaseKatello 2.3.1Release relationshipAuto

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
Added by Justin Sherrill over 2 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 over 2 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 over 2 years ago

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

#2 Updated by Justin Sherrill over 2 years ago

  • Assigned To set to Justin Sherrill
  • Release set to Katello 2.3.1
  • Difficulty set to easy
  • Triaged changed from No to Yes

#3 Updated by Justin Sherrill over 2 years ago

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

Also available in: Atom PDF