Project

Profile

Help

Refactor #994

closed

Repository content_unit counts should be calculated using the mongo aggregation framework

Added by bcourt almost 9 years ago. Updated about 5 years ago.

Status:
CLOSED - WONTFIX
Priority:
Normal
Assignee:
-
Category:
-
Sprint/Milestone:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Platform Release:
Groomed:
No
Sprint Candidate:
No
Tags:
Pulp 2
Sprint:
Quarter:

Description

Currently the unit counts on repositories is calculated by atomically adding or subtracting values from the current value. Pulp should let mongo calculate these values for us using an aggregation query:
db.repo_content_units.aggregate({'$match':{'repo_id': '<repo_id>'}}, {'$group': {'_id':'$unit_type_id','sum' :{'$sum':1}}})

With some general testing this query took 0.12 seconds on a repository with 11k total packages (3k erratum and 8k rpm)

Also available in: Atom PDF