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

Bill Burke bburke at redhat.com
Mon May 29 16:33:13 EDT 2017


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



More information about the keycloak-dev mailing list