Large number of groups ~ 32 thousand select count(*) from groups 31912 select count(*) from group_subgroup 36536 select count(*) from user_group 16691 select count(*) from explicit_entitlement 11152 11k entitlements. There are ~12 groups that are members(sub groups) of thousands of groups. It is one of these subgroupds that is experiencing the problem.

The query causing the problem, searched 134 gig of data on a machine with 20 meg of database