Issue Summary

When loading the Releases page of a deployment project or running a new deployment and selecting "Promote existing release to this environment", Bamboo runs SQL queries that retrieve the details and information about all the releases tied to that deployment. In large data environments where releases have not been purged over time, the long list of releases to be loaded can cause slowness/sluggishness. 

Steps to Reproduce

N/A

Expected Results

Performance-wise, it would be more interesting to load the data about only the most recent releases and retrieve the data about older releases only once the user chooses one of those to deploy.

Actual Results

The release page of a deployment project & the new deployment page when selecting Promote existing release to this environment load all the data from all releases tied to that deployment project (artifacts, deployment status, commits, results, etc.), which can cause slowness and sluggishness on certain types of Bamboo instances.

Example of tables that Bamboo checks:

DEPLOYMENT_VERSION_ITEM_BA
ARTIFACT
DEP_VERSION_PLANRESULTKEYS
DEPLOYMENT_VERSION_CHANGESET
DEPLOYMENT_VERSION
DEPLOYMENT_VERSION_ITEM
DEPLOYMENT_VERSION_STATUS
DEPLOYMENT_RESULT
DEPLOYMENT_VERSION_COMMIT

Workaround

The only workaround is to manually remove the older, no longer-used releases by deleting them through the User Interface.