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

Add indexes to optimize biological entity endpoints #89

Open
AlanSimmons opened this issue Apr 17, 2024 · 1 comment · Fixed by #90
Open

Add indexes to optimize biological entity endpoints #89

AlanSimmons opened this issue Apr 17, 2024 · 1 comment · Fixed by #90
Assignees
@AlanSimmons
Labels
dependencies Pull requests that update a dependency file enhancement New feature or request HuBMAP/SenNet

Comments

@AlanSimmons
Copy link
Contributor

Statement of issue

Calls to endpoints like /gene-info are slow.

Solution

Add relevant indexes to optimize the endpoint queries.
@AlanSimmons AlanSimmons added enhancement New feature or request HuBMAP/SenNet dependencies Pull requests that update a dependency file labels Apr 17, 2024
@AlanSimmons AlanSimmons self-assigned this Apr 17, 2024
@AlanSimmons
Copy link
Contributor Author

I moved the SKIP and LIMIT clauses in the Cypher queries. This seems to speed the corresponding endpoints somewhat.

@AlanSimmons AlanSimmons linked a pull request Apr 30, 2024 that will close this issue
improvements to searching on starts_with parameter in genes-info etc. #90
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@AlanSimmons AlanSimmons

Labels
dependencies Pull requests that update a dependency file enhancement New feature or request HuBMAP/SenNet
Projects
@UBKG (Unified Biomedical Knowledge Graph) Project
Archived in project
Milestone
No milestone
1 participant
@AlanSimmons