[keycloak-dev] avoiding extra sql

FYI: In some places like getClientById, we check the passed in RealmModel.getId() against ClientEntity.getRealm().getId() to make sure its the same realm. This causes an extra SELECT query on the realm. To avoid this, you can set the access to the primary key to property and the id will be obtained only without a sql query. public class RealmEntity { @Id @Column(name="ID", length = 36) @Access(AccessType.PROPERTY) protected String id; -- Bill Burke JBoss, a division of Red Hat http://bill.burkecentral.com