OPS: Profile and improve parentDSTrio API #144
Description
Impact of the operational activity
Current parentDSTrio GET HTTP API may take lots of time, see attached plot.
Describe the operational activity
Revisit, provide and improve DSTrio ORACLE query
Is it a regular activity?
No
Dependencies on external repository changes
None
Additional context
It may be wise to contact CERN DBA to gather statistics about DSTrio query and identify cases when it takes lots of time to respond. Then, ask DBA to optimize the query or suggest how to better do it.
