Grouper Developers Forum

["Black, Carey M." <>]

Using: 
Grouper: v2.3 (latest patches)
RDBMS: Mysql 10.2.16 ( MariaDB)

My DBA is telling me that this query is showing up in the slow log ( this one 
is taking about 75 seconds, and happening "often" )

Example search:

select distinct composite2_.owner as col_0_0_, composite2_.id as col_1_0_, 
member1_.id as col_2_0_ 
from grouper_memberships_all_v membership0_ 
        cross join grouper_members member1_ 
        cross join grouper_composites composite2_ 
where composite2_.type='union' 
        and (composite2_.left_factor=membership0_.owner_group_id or 
composite2_.right_factor=membership0_.owner_group_id) 
        and membership0_.field_id='6142a7efff744cfd8a9dae4058c5d64b' 
        and membership0_.immediate_mship_enabled='T' 
        and membership0_.member_id=member1_.id 
        and member1_.subject_source<>'g:gsa' 
        and  not (exists (
                select 1 
                from grouper_memberships immediatem3_ 
                where immediatem3_.owner_group_id=composite2_.owner 
                        and immediatem3_.member_id=member1_.id 
                        and 
immediatem3_.field_id='6142a7efff744cfd8a9dae4058c5d64b' 
                        and immediatem3_.mship_type='composite' 
                        and immediatem3_.enabled='T'
                        ));

Can you identify what in grouper is making that query?
Is there anything that could be done to improve the performance of that 
query? ( a new index maybe? )

-- 
Carey Matthew