Project

Profile

Help

Task #6742

Add indexes to the models for better performance

Added by ipanova@redhat.com over 1 year ago. Updated 6 months ago.

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

100%

Estimated time:
Platform Release:
Groomed:
No
Sprint Candidate:
No
Tags:
Sprint:
Sprint 94
Quarter:
Q2-2021

Description

for example for pulp2lazycatalog we'd have:

indexes = [

  •        models.Index(fields=['pulp2_content_type_id']),
    
  •        models.Index(fields=['pulp2_id']),
    
  •        models.Index(fields=['pulp2_last_updated'])
    

Associated revisions

Revision e689a459 View on GitHub
Added by ttereshc 6 months ago

Add missing indices

It should potentially improve performance of some queries a bit. No benchmarking is done, just those fields are used in various queries.

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

Revision e689a459 View on GitHub
Added by ttereshc 6 months ago

Add missing indices

It should potentially improve performance of some queries a bit. No benchmarking is done, just those fields are used in various queries.

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

Revision e689a459 View on GitHub
Added by ttereshc 6 months ago

Add missing indices

It should potentially improve performance of some queries a bit. No benchmarking is done, just those fields are used in various queries.

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

History

#1 Updated by ttereshc 7 months ago

  • Status changed from NEW to ASSIGNED
  • Assignee set to ttereshc
  • Sprint set to Sprint 93
  • Quarter set to Q2-2021

#3 Updated by ttereshc 7 months ago

  • Status changed from ASSIGNED to POST

#4 Updated by rchan 6 months ago

  • Sprint changed from Sprint 93 to Sprint 94

#5 Updated by ttereshc 6 months ago

  • Status changed from POST to MODIFIED
  • % Done changed from 0 to 100

#6 Updated by ttereshc 6 months ago

  • Sprint/Milestone set to 0.11.0

#7 Updated by pulpbot 6 months ago

  • Status changed from MODIFIED to CLOSED - CURRENTRELEASE

Please register to edit this issue

Also available in: Atom PDF