Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

feat: Add db index to License.status field #575

Merged
merged 1 commit into from
Jan 29, 2024
Merged

Conversation

pwnage101
Copy link
Contributor

@pwnage101 pwnage101 commented Jan 27, 2024

This field is used by the license REST APIs for sorting and filtering, as well as all endpoints which contain license counts by status, which makes it a good candidate for being indexed.

ENT-8271

Copy link
Contributor

@iloveagent57 iloveagent57 left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

I wonder if we actually want a composite index on (subscription_plan, status) - I image that’s the actual read pattern we’d use for listing/filtering, right?

@pwnage101
Copy link
Contributor Author

Yep, that's right, the only time we list/retrieve all licenses is within the context of a single subscription plan. I didn't know a composite indexes were a thing, I'll look into them.

@pwnage101 pwnage101 marked this pull request as draft January 29, 2024 16:59
@pwnage101 pwnage101 marked this pull request as ready for review January 29, 2024 20:28
This field is used by the license REST APIs for sorting and filtering,
as well as all endpoints which contain license counts by status, which
makes it a good candidate for being indexed.

ENT-8271
@pwnage101 pwnage101 merged commit 19c49fa into master Jan 29, 2024
7 checks passed
@pwnage101 pwnage101 deleted the pwnage101/ENT-8271 branch January 29, 2024 22:50
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

2 participants