Grouper Users - Open Discussion List

[Shilen Patel <>]

Similar question:  Is groupB a member of many groups or does groupB have a
lot of privileges to other groups/stems?

Also, what client were you using when making this update (admin UI, lite
UI, your own UI, web services, GSH/API)?  If you haven't tried with GSH,
can you try there too?  Maybe you can set hibernate.show_sql=true and see
if there's a particular query that's stalling or if there's a continuous
loop of sql statements.

Thanks!

-- Shilen

On 12/4/12 12:02 PM, "Jim Fox" 
<>
 wrote:

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