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

[Stian Thorgersen]

If you look at the attached issue (
https://issues.jboss.org/browse/KEYCLOAK-4964) it looks like we currently
end up with doing thousands of queries instead. So how do you propose we
solve this?

On 29 May 2017 at 22:33, Bill Burke <bburke at redhat.com> wrote:

> Don't think that's a good idea.  We have users  that have thousands of
> roles and groups.
>
>
> On 5/29/17 5:58 AM, Stian Thorgersen 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.
> > _______________________________________________
> > keycloak-dev mailing list
> > keycloak-dev at lists.jboss.org
> > https://lists.jboss.org/mailman/listinfo/keycloak-dev
>
> _______________________________________________
> keycloak-dev mailing list
> keycloak-dev at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/keycloak-dev
>