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

Selecting a single or small number of records by something other than ID takes much longer #8142

Open
droyad opened this issue May 12, 2023 · 1 comment
Assignees
Labels
kind/bug This issue represents a verified problem we are committed to solving

Comments

@droyad
Copy link
Contributor

droyad commented May 12, 2023

[sc-49817]

Severity

Annoyance

Version

2022.1 onwards as each endpoint was modernised

Latest Version

I could reproduce the problem in the latest build

What happened?

The API call /api/projects/foo (foo being the slug) takes much longer than the call /api/projects/Projects-1 .

This occurs when there are 1000's of projects.

It is likely similar endpoints, Environments, Tenants, Tags, etc are affected in the same way

Reproduction

Create 5,000 projects
Select one by slug, takes about 500ms
Select one by id, takes about 50ms

Error and Stacktrace

No response

More Information

No response

Workaround

No response

@droyad droyad added the kind/bug This issue represents a verified problem we are committed to solving label May 12, 2023
@droyad
Copy link
Contributor Author

droyad commented Jun 7, 2023

I'm keeping this open for further investigation as improvements for small record sets make the large record sets slow.

However #8184 fixes the issue with project slugs.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
kind/bug This issue represents a verified problem we are committed to solving
Projects
None yet
Development

No branches or pull requests

1 participant