Project

General

Profile

Actions
Copy link

Bug #20019

open

cache errata counts on objects

Added by Justin Sherrill almost 8 years ago. Updated 8 months ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
Performance
Target version:
-
Difficulty:
Triaged:
Bugzilla link:
Pull request:
Fixed in Releases:
Found in Releases:
Red Hat JIRA:

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

Actions
Copy link
 #1

Updated by Tomer Brisker almost 8 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)

Actions
Copy link
 #2

Updated by Justin Sherrill almost 8 years ago

  • Category set to Performance
  • Translation missing: en.field_release set to 114
Actions
Copy link
 #3

Updated by Ian Ballou 8 months ago

  • Target version deleted (Katello Backlog)
Actions
Copy link

Also available in: Atom PDF