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.

Sign up for GitHub

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

Jump to bottom

Improve study query performance #619

Open
dankolbman opened this issue Apr 15, 2021 · 0 comments
Open

Improve study query performance #619

dankolbman opened this issue Apr 15, 2021 · 0 comments
Labels
refactor Something needs to be done better

Comments

@dankolbman
Copy link
Contributor

The study and allStudies queries are slow as they are performing many sequential SQL queries.
Using data loaders or prefetching relationships help reduce some of the linear scaling in the queries, but there are still issues trying to reduce n+1 on the Membership fields when resolving collaborators.

Current Performance

Screen Shot 2021-04-15 at 9 52 34 AM

Screen Shot 2021-04-15 at 9 53 25 AM
@dankolbman dankolbman added the refactor Something needs to be done better label Apr 15, 2021
@dankolbman dankolbman mentioned this issue Apr 26, 2021
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
refactor Something needs to be done better
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@dankolbman