Grouper Users - Open Discussion List

[Jim Fox <>]

> A few questions to try to narrow down the problem:
>
> Does groupA have many members that are groups (either directly or
> indirectly)?  If so, the issue may be related to many groupSets being
> added.

No, groupA is just people.

> Is groupB a factor in any composite (either directly or indirectly)?  If
> so, the issue may be related to many composite memberships being added
> (possibly 150K for each composite group).

No, we don't use composites.

> What do you have groups.updateLastMembershipTime set to?

groups.updateLastMembershipTime = false

> Did you try analyzing all the grouper tables?

Not just before this, but I believe our DBAs do an analyze once a week.

Jim


> Thanks!
>
> -- Shilen
>
> On 12/3/12 4:58 PM, "Jim Fox" 
> <>
>  wrote:
>
> > version 1.6.1
> >
> > Jim
> >
> >
> > On Mon, 3 Dec 2012, Chris Hyzer wrote:
> >
> > > Date: Mon, 3 Dec 2012 13:55:40 -0800
> > > From: Chris Hyzer 
> > > <>
> > > To: Jim Fox 
> > > <>,
> > >     grouper users list 
> > > <>
> > > Subject: RE: [grouper-users] adding large group as member group is slow
> > >
> > > What grouper version are you using exactly?
> > >
> > > -----Original Message-----
> > > From: 
> > >
> > > [mailto:]
> > >  On Behalf Of Jim Fox
> > > Sent: Monday, December 03, 2012 4:51 PM
> > > To: grouper users list
> > > Subject: [grouper-users] adding large group as member group is slow
> > >
> > >
> > > Suppose groupA has membership of 150K members.
> > >
> > > I add groupA as a member to groupB.
> > >
> > > That add takes several hours.
> > >
> > > What's going on?
> > > Is there any configuration that would speed it up?
> > > Are any tables locked during the add?
> > >
> > > Thanks,
> > >
> > > Jim