Another related thing. I believe we currently look for composite roles
cross realms, which is not ideal. This comes down to admin master realm I
believe.
On 29 May 2017 at 11:58, Stian Thorgersen <sthorger(a)redhat.com> wrote:
When we initially load a realm there are a lot of queries going to
the db.
A lot of things are fetched lazily which results a large number of queries.
For example to load roles see
https://issues.jboss.org/
browse/KEYCLOAK-4964.
How feasible would it be to have a single query that fetches most things
(if not everything) when a realm is initially loaded? We could at least
fetch all realm data including roles and composites, but excluding clients
and users.