Grouper Users - Open Discussion List

[Shilen Patel <>]

We have the default indexes on the grouper_memberships table including:

membership_owner_idx
membership_field_idx
membership_type_idx

But we added the following:

CREATE INDEX GROUPER_MEMBERSHIPS_IDX1 on GROUPER_MEMBERSHIPS 
("OWNER_ID","LIST_NAME","LIST_TYPE","MSHIP_TYPE");


-- Shilen



blair christensen. wrote:
> On 6/18/07, Shilen Patel 
> <>
>  wrote:
> > 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.