Project

General

Profile

Actions

Bug #38086

open

Products index page is slow for products that have no synced repositories

Added by Ian Ballou about 2 months ago. Updated 3 days ago.

Status:
Ready For Testing
Priority:
Normal
Assignee:
Category:
Repositories
Target version:
Difficulty:
Triaged:
Yes
Fixed in Releases:
Found in Releases:

Description

Discussion: https://community.theforeman.org/t/slow-product-page/40279/

In app/models/katello/glue/pulp/repos.rb#last_sync, Katello first searches for repo sync tasks and then audits if no sync tasks show up when attempting to find a sync time for repositories within the product.

However, if the product has no synced synced repositories, it seems that the audits search is very slow. It may be because the lack of audit record is causing the entire audit table to be scanned.

Should the last sync time be stored on the product itself?

Actions #1

Updated by Ian Ballou about 2 months ago

  • Assignee set to Samir Jha
  • Triaged changed from No to Yes
Actions #2

Updated by The Foreman Bot 3 days ago

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

Updated by Samir Jha 3 days ago

  • Triaged changed from Yes to No
Actions #4

Updated by Samir Jha 3 days ago

  • Red Hat JIRA set to SAT-30118
Actions #5

Updated by Samir Jha 3 days ago

  • Target version changed from Katello Next to Katello 4.16.0
  • Triaged changed from No to Yes
Actions

Also available in: Atom PDF