Grouper Users - Open Discussion List

[Jim Fox <>]

It's our own UI, but making a standard grouper API call.  The groupB is also 
simple.

I'm doing some more testing.

Jim

On Dec 4, 2012, at 9:56 AM, Shilen Patel wrote:

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