Reduce identity list amount of sub-queries

[aeneasr]

Describe the bug

Currently, we are performing one large query (SELECT * FROM identities) and several sub-queries per identity (findVerifiableAddresses, findRecoveryAddresses, injectTraitsSchemaURL) which can be quite slow once several identities exist in the database.

Expected behavior

We should reduce the amount of queries and check if we are missing any keys to improve query performance.

Environment

• Version: master

[aeneasr]

Ok, so the problem is not the queries themselves but instead that we run the sub-queries sequentially. Instead it might make sense to either do all of this in one query or alternatively run the subqueries in a parallelized fashion. See the jaeger trace:

Bildschirmaufnahme.2021-06-11.um.18.19.46.mov