How to optimize this GORM query
I have a query which makes 2 database queries. I am new to GORM and don't
know how to optimize it into 1 query using criteria, or a where clause or
something else. I'm using springsecurity as well and have a User class for
login security. I have a Profile class with a User object:
class Profile {
User user
}
In my controller the session stores the user id. When I want to load the
profile to update it my code is currently:
def user = User.get(springSecurityService.principal.id) // 1st db query
def domainObject = Profile.findByUser(user) // 2nd db query
I've tried a few query variations through trial and error but can't seem
to find one that doesn't generate an error. This seems like it would be
trivial. The pseudo-query would be 'get me the profile for the
profile.user that has this user id'.
No comments:
Post a Comment