Investigate implications of opting for a single database transaction over concurrent requests

[rtkay123]

Story statement

As a developer of the platform I want to ensure I am querying the database optimally, as such I want to verify if sequential calls provide a negligible difference to using a single transaction **So that my application is optimised and uses its dependencies in the most efficient manner

Acceptance criteria

1. Wrap sequential database calls to the same database in a single transaction and investigate whether there's a performance change

[Justus-at-Tazama]

Is this user story similar to this: https://github.com/frmscoe/docs/issues/90 (Gather outgoing asynchronous requests) -

• https://en.wikipedia.org/wiki/Vectored_I/O
• https://www.javatpoint.com/scatter-gather-or-vectored-input-output