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

Timeout issue with /datasets/unpublished Neo4j query #518

Open
yuanzhou opened this issue Jul 24, 2023 · 0 comments
Open

Timeout issue with /datasets/unpublished Neo4j query #518

yuanzhou opened this issue Jul 24, 2023 · 0 comments
Assignees
@DerekFurstPitt

Comments

@yuanzhou
Copy link
Member

Sunset also reported a timeout issue:

I'm also facing timeouts with entity-api (https://entity.api.hubmapconsortium.org/datasets/unpublished?format=json) I know this should be a big query.

Essentially it's a neo4j cypher with OPTIONAL MATCH which is causing performance issue thus timed out.

From Derek:

Yep that was my suspicion as well. The fix should be reasonably simple. If I can't find a way to restructure the original query, worst case scenario, splitting into 2 queries should drastically speed things up.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@DerekFurstPitt DerekFurstPitt

Labels
None yet
Projects
Pitt HIVE
Status: Backlog
Milestone
No milestone
Development

No branches or pull requests
2 participants
@yuanzhou @DerekFurstPitt