Issue 45713: Perf : slow query cleaning up provenance for linked to study assay data

issues
Status:closed
Assigned To:Guest
Type:Defect
Area: 
Priority:3
Milestone:22.07
Opened:2022-06-16 17:14 by Karl Lum
Changed:2022-07-11 23:04 by Keith
Resolved:2022-06-22 14:14 by Karl Lum
Resolution:Fixed
Related:45602
Support Ticket: 
Pull Requests:provenance#107
Closed:2022-07-11 23:04 by Keith
2022-06-16 17:14 Karl Lum
Title»Perf : slow query cleaning up provenance for linked to study assay data
Assigned To»Karl Lum
Type»Defect
Priority»3
Milestone»22.07
Related»45602
ProvenanceService.getRunIds can be expensive especially if the DB contains many entries in the exp.object and provenance.protocolApplicationObjectMap.

2022-06-21 16:36 Karl Lum
Pull Requests»https://github.com/LabKey/provenance/pull/107

2022-06-22 14:14 Karl Lum
resolve as Fixed
Statusopen»resolved
Assigned ToKarl Lum»Keith
this has been merged into develop, you can push a release22.7-SNAPSHOT build to the client to test.

2022-07-11 23:04 Keith
close
Statusresolved»closed
Assigned ToKeith»Guest
To be tested on the client's test server.