TRSS: Performance Improvements To Interactions with MongoDB

Following the works done in https://github.com/adoptium/infrastructure/issues/3877

and more specifically highlighted queries causing contention and reduced performance in comment https://github.com/adoptium/infrastructure/issues/3877#issuecomment-2693852385

Involving aggregation queries and deletes being improved.

Some investigation and adjustments to those queries are necessary when involving large datasets.

Start by reading issue 3877 and its linked comment, then locate the aggregation queries and deletes in this repository that correspond to the reported contention. Investigate their behavior on large datasets and measure whether adjustments reduce contention and improve performance; completion criteria are not specified in this issue.

Written by the indexing model from the issue text.