Performance optimization for `EnvironmentFinder`
EnvironmentFinder causes performance issue, like #325552 (closed). In the past, we discussed a couple of times that we should refactor this finder due to the bunch of performance issue by the unnecessarily complicated functionalities (Also, it's very old), however, we've not done any actual action yet (AFAIK). Maybe it's good time to revisit this issue.
There is also inconsistency in code that there is no SSOT facility to fetch-and-filter environments i.e. some places use the finder, the other places directly access
Environment model without using the finder. So that the performance issue tends to appear sparsely across different domains. Ideally, Release group provides a SSOT facility and we keep maintaining the finder with decent optimization for the other domains.