Project

Profile

Help

Refactor #6373

closed

Improve content stages performance

Added by dalley almost 5 years ago. Updated over 4 years ago.

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

100%

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

Description

placeholder issue for general performance improvements to the content stages

Added by dalley almost 5 years ago

Revision 216b14ce | View on GitHub

Dramatically increase re-sync performance

Increase the performance of the QueryExisting* stages. pulp_created=None was originally picked because it wouldn't match with anything, and an empty Q() object matches with everything. But it's a lookup on an unindexed field that requires looking at an entirely different table, so it ends up being incredibly inefficient. It turns out that there is a way to accomplish the same thing that gets compiled out of the query entirely.

closes: #6373 https://pulp.plan.io/issues/6373

Actions #1

Updated by dalley almost 5 years ago

  • Status changed from POST to MODIFIED
  • % Done changed from 0 to 100
Actions #2

Updated by ttereshc over 4 years ago

  • Status changed from MODIFIED to CLOSED - CURRENTRELEASE
  • Sprint/Milestone set to 3.3.0

Also available in: Atom PDF