Project

General

Profile

Bug #20019

cache errata counts on objects

Added by Justin Sherrill about 2 years ago. Updated about 1 year ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
Performance
Target version:
Difficulty:
Triaged:
Yes
Bugzilla link:
Pull request:
Team Backlog:
Fixed in Releases:
Found in Releases:

Description

Currently with rails we cannot retrieve a list of objects that contain errata without creating an N+1 query this would be on:

hosts (content facet)
repositories
content view versions

This would also allow the CSV export to include errata counts: https://github.com/Katello/katello/pull/6814

History

#1 Updated by Tomer Brisker about 2 years ago

I would encourage not to rely on Rails' counter_cache for this, we've had very bad issues with deadlocks in core caused by it until we eventually completely removed it. (https://github.com/theforeman/foreman/pull/3596)

#2 Updated by Justin Sherrill about 2 years ago

  • Category set to Performance
  • Legacy Backlogs Release (now unused) set to 114

Also available in: Atom PDF