search

cBioPortal / rfc80-team

repository to hold issues for the rfc80 development / deployment team
0 stars 0 forks source link

Molecular profile count service query can be simplified using genomic_event_derived #28

Open alisman opened 2 weeks ago

alisman commented 2 weeks ago

The filter for molecular profile counts (genomicProfiles filters) uses joins which are already handled in a derived table.

src/main/resources/org/cbioportal/persistence/mybatisclickhouse/StudyViewFilterMapper.xml

The genomic_event_derived table has this info without the need of a join.