INCATools / INCATools/ontology-access-kit

Optimization: `SqlImplementation.relationships_metadata()`

Open
#660 0 comments 0 reactions 0 assignees View on GitHub
enhancement
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.