Bug #38086: Products index page is slow for products that have no synced repositories - Katello - Foreman

Actions

Copy link

Bug #38086

closed

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

Added by Ian Ballou 3 months ago. Updated 20 days ago.

Status:

Closed

Priority:

Normal

Assignee:

Samir Jha

Category:

Repositories

Target version:

Katello 4.16.0

Difficulty:

Triaged:

Yes

Bugzilla link:

Pull request:

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

Fixed in Releases:

Katello 4.16.0

Found in Releases:

Red Hat JIRA:

SAT-30118

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?