Project

Profile

Help

Task #6742

closed

Add indexes to the models for better performance

Added by ipanova@redhat.com over 4 years ago. Updated over 3 years 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'])
    
Actions #1

Updated by ttereshc over 3 years ago

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

Updated by ttereshc over 3 years ago

  • Status changed from ASSIGNED to POST
Actions #4

Updated by rchan over 3 years ago

  • Sprint changed from Sprint 93 to Sprint 94

Added by ttereshc over 3 years ago

Revision e689a459 | View on GitHub

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

Added by ttereshc over 3 years ago

Revision e689a459 | View on GitHub

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

Added by ttereshc over 3 years ago

Revision e689a459 | View on GitHub

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

Actions #5

Updated by ttereshc over 3 years ago

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

Updated by ttereshc over 3 years ago

  • Sprint/Milestone set to 0.11.0
Actions #7

Updated by pulpbot over 3 years ago

  • Status changed from MODIFIED to CLOSED - CURRENTRELEASE

Also available in: Atom PDF