Skip to Content.
Sympa Menu

grouper-users - Re: [grouper-users] Performance Issues With 1.2 rc3

Subject: Grouper Users - Open Discussion List

List archive

Re: [grouper-users] Performance Issues With 1.2 rc3

Chronological Thread 
  • From: Shilen Patel <>
  • To: "blair christensen." <>
  • Cc:
  • Subject: Re: [grouper-users] Performance Issues With 1.2 rc3
  • Date: Mon, 18 Jun 2007 13:04:05 -0400

We have the default indexes on the grouper_memberships table including:


But we added the following:


-- Shilen

blair christensen. wrote:
On 6/18/07, Shilen Patel
Our DBAs have added an index that significantly improves performance for
group and stem deletes in our environment. However, the stem deletes
are still much slower than what we saw in Grouper 1.1. We added an
index on the grouper_memberships table for the columns owner_id,
list_name, list_type, and mship_type.

Odd. All of those should already be indexed in 1.2.0rc3.

Is it possible that your db schema was not properly generated? Or
perhaps was generated using the wrong Hibernate dialect? It sounds
like you might be missing one (or more) other indexes that should have
been created by default.

Archive powered by MHonArc 2.6.16.

Top of Page