Skip to Content.
Sympa Menu

grouper-users - Re: [grouper-users] Group Membership Queries

Subject: Grouper Users - Open Discussion List

List archive

Re: [grouper-users] Group Membership Queries

Chronological Thread 
  • From: "blair christensen." <>
  • To: "Shilen Patel" <>
  • Cc:
  • Subject: Re: [grouper-users] Group Membership Queries
  • Date: Tue, 7 Aug 2007 11:06:51 -0500
  • Domainkey-signature: a=rsa-sha1; c=nofws;; s=beta; h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth; b=RILB72XCiSYZPLkMCEVtoxbUZD4y+0MT1XL9rc7upD4YPGb2wEs1D7PHFzngKB/u9sWv7c9CBucowNVgFul06EB6VLXtAwQDXea7jYa6/zZaL4T8Br+o1cFGrj4mCEZ8+AorPPE09P2m3N+A7mvAgsP0rRMiR1D9+5bOirTGjdg=

On 7/30/07, Shilen Patel
> This is just a quick follow up to the previous email to mention how this
> operation can be improved. As mentioned before, if you want to run
> Group.getMembers() on a group with 30,000 members, there will be 30,000
> SELECT queries on the grouper_members table.
> You can easily reduce that down to 1 query using a join like the
> following where you're getting all members in a specified group.
> Thoughts?

Thanks for sending this along. It could be a substantial improvement.
I haven't had a chance to look closely at it yet but I've added it to
Jira as GRP-22.

  • Re: [grouper-users] Group Membership Queries, blair christensen., 08/07/2007

Archive powered by MHonArc 2.6.16.

Top of Page