querying vs using relationship list and iterate

From: Nishant Neeraj (nishant.has.a.questio..mail.com)
Date: Tue Jun 08 2010 - 14:41:39 UTC

  • Next message: Michael Gentry: "Re: querying vs using relationship list and iterate"

    Hi,

    I have three tables USERS, MEMBERSHIPS, GROUPS -- where membership is a
    linking table that joins users and groups in many-to-many relationship, and
    also stores users' role in the group.

    Sometime when I need to know whether a user exists in a group [or what role
    a user has in a group], I can do it by two ways:

    1. groups.getMembershipList() and iterate over the list inflating each
    member and comparing with the User object that is on test. like

    for(Membership m: g.getMembershipList())
    {
       if(m.getUser().equals(testUser)
           return true;
    }

    Or.

    2. I can just write a query using Expression.

    Expression.forString(Membership.class, "user = $testUser and group=$group");

    Can someone suggest which one is better approach? Or, is there a even better
    third approach?

    Thanks
    Nishant

    This archive was generated by hypermail 2.0.0 : Tue Jun 08 2010 - 14:42:12 UTC