INCATools / INCATools/ontology-access-kit
Optimization: `SqlImplementation.relationships_metadata()`
- Dominant language
- Python
- Stars
- 198
- Forks
- 35
- Avg merge
- 3d 4h
- Merged PRs (30d)
- 1
Description
## Overview
@cmungall recently added _ability to retrieve axiom annotations on relationships_ (#656), but there is a significant performance bottleneck. I noticed this during my [`mondo-ingest` synchronization pipeline work](https://github.com/monarch-initiative/mondo-ingest/pull/363#discussion_r1336501888). This operation was taking 104 minutes to complete.
## Possible solutions
- #659
Contributor guide
Research direction
Start by locating SqlImplementation.relationships_metadata() and read the performance context from mondo-ingest synchronization work. Review the possible solution in issue #659 and compare its approach with the current operation. Done means the relationship metadata retrieval no longer has the reported performance bottleneck, with validation based on the synchronization workflow.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- python, sql
- Domain
- databases
- Issue type
- Refactor
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 25/100