[keycloak-dev] Reducing queries when initially loading a realm

[Stian Thorgersen]

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 at 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.
>