Project

General

Profile

Actions

Bug #38086

open

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

Added by Ian Ballou 6 days ago. Updated 6 days ago.

Status:
New
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 6 days ago

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

Also available in: Atom PDF