Issue Summary

This is reproducible on Data Center: (yes)

Steps to Reproduce

1. Create an enterprise sized instance with over 1 million deployment environments
2. Access the /rest/api/latest/deploy/project/ {id}

   either manually or automatically

Expected Results

Results returned within a reasonable period of time.

Actual Results

Results are returned after approximately 20 minutes, heavy DB load while waiting.

If many calls to the endpoint are made it may saturate the HTTP Pool.

Workaround

Currently there is no known workaround for this behavior. A workaround will be added here when available