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:26:35 -0400

I just listed a subset of the indexes we have on that table that involved the columns in the index we created. Here are all the indexes we have on grouper_memberships.

grouper_memberships_idx1 -- The one we created.
membership_createtime_idx
membership_creator_idx
membership_depth_idx
membership_field_idx
membership_member_idx
membership_owner_idx
membership_parent_idx
membership_type_idx
membership_uuid_idx
membership_via_idx
sys_c0018798 - created from the primary key.
sys_c0019799 - created from the unique key

Am I missing anything that should have been created by default? I also don't have any errors in those two log files.

Thanks,

-- Shilen



blair christensen. wrote:
On 6/18/07, Shilen Patel
<>
wrote:
We have the default indexes on the grouper_memberships table including:

membership_owner_idx
membership_field_idx
membership_type_idx

Your schema isn't being generated properly for some reason on this
table (if not other tables as well). There are (ugh) 10 different
indexes that should be created by default on the "grouper_memberships"
table.

It is possible that any errors arising during the schema creation
might be logged in either the "GROUPER_HOME/schemaexport.log" or
"GROUPER_HOME/grouper_error.log".




Archive powered by MHonArc 2.6.16.

Top of Page