Skip to Content.
Sympa Menu

grouper-users - Grouper Performance and UI Questions

Subject: Grouper Users - Open Discussion List

List archive

Grouper Performance and UI Questions

Chronological Thread 
  • From: Shilen Patel <>
  • To:
  • Subject: Grouper Performance and UI Questions
  • Date: Tue, 29 May 2007 10:39:35 -0400


I'm noticing some performance issues when we have a large number of groups and memberships. When we have a clean install of the database, it takes the following times to perform common operations using the Grouper 1.1 API.

Starting a session: 3.264
Find stem: 0.069
Create 10 stems: 2.316
Delete 10 stems: 2.346
Create 10 groups: 5.208
Delete 10 groups: 8.61
Add 10 members to 1 group: 0.828
Delete 10 members one at a time from 1 group: 2.282

However, our production database has about 101,000 entries in the grouper_groups table and 1,064,000 entries in the grouper_memberships table. In this environment, the same operations above take much longer.

Starting a session: 4.083
Find stem: 0.079
Create 10 stems: 7.939
Delete 10 stems: 12.645
Create 10 groups: 9.889
Delete 10 groups: 25.758
Add 10 members to 1 group: 1.971
Delete 10 members one at a time from 1 group: 4.97

So my questions are:

1. Is this type of performance decline a known issue? Is there something we can do to improve the performance when we have so many groups and memberships? How long does it take others to add and delete stems, groups, and members?

2. Do any other universities have a Grouper deployment with a hundred thousand groups and a million memberhips?

3. We also have some concerns about the usability of the Grouper UI. In other universities, what kinds of users are using the Grouper UI? For instance, is the Grouper UI released to every student and employee or perhaps only a few IT employees?


-- Shilen

Archive powered by MHonArc 2.6.16.

Top of Page