Subject: Grouper Developers Forum
- From: "Black, Carey M." <>
- To: "" <>
- Subject: [grouper-dev] v2.3 "slow query"
- Date: Tue, 16 Apr 2019 14:43:27 +0000
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" )
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_
and (composite2_.left_factor=membership0_.owner_group_id or
and not (exists (
from grouper_memberships immediatem3_
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? )
- [grouper-dev] v2.3 "slow query", Black, Carey M., 04/16/2019
Archive powered by MHonArc 2.6.19.