Grouper Users - Open Discussion List

[Shilen Patel <>]

Hi,

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.

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).

What do you have groups.updateLastMembershipTime set to?

Did you try analyzing all the grouper tables?

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
>>
>>